[AccessD] Email Problem

Hi Stuart,
As I mentioned in another message, Blat requires an ISP's SMTP setting. I
need our own PCs to act as the SMTP (locally).  This is entirely do-able, I
just need to code.  A simple session would send from my local host via a dns
server where it would lookup the MX IP address for the email and then send
the email on.  Therefore, no copy would go via any ISP - there would be no
security worries - just an email from one pc to another pc.

Thanks
Max


On Mon, Sep 22, 2008 at 10:36 PM, Stuart McLachlan
<stuart at lexacorp.com.pg>wrote:

> You can't check an address without sending a message to it.
> (Well there is the SMTP VERIFY command, but most servers
> don't honour it to avoid disclosing valid addresses to spammers)
>
> I use Blat.dll to do this sort of automated mailing. Every transmission is
> logged
> in a text file which you can programmatically check for errors afterwards.
> It also
> returns error codes which you can use to create your own logging routine.
>
>
> Having said that how about a standard error trap:
>
> Do
>   On error goto trapit:
>   Docmd.sendmail... or whatever
>   On error goto 0
> loop.........
> ..........
> exit function
> trapit:
> if error = -21472220977 then
>   Log toAddress
>   resume next
> end if
> .......
>
>
> with your own custom Log() function
>
>
> On 22 Sep 2008 at 13:17, Rocky Smolin at Beach Access  wrote:
>
> > Dear List:
> >
> > My day for questions.  I'm sending emails automatically, unattended, from
> > this app - scheduled to run at night.  When the email contains an invalid
> > address it generates an error "-21472220977 - the server rejected one or
> > more recipient addresses.  The server response was 550 5.1.1 User
> Unknown.
> > Possible bad email address"
> >
> > then it lists all of the addresses in the To: CC: and BCC: fields, and
> the
> > process stops until the user comes in, sees the message and clicks OK.
>  At
> > which point they don't really know what address was bad.
> >
> > I suppose I could use On Error Resume Next at the line which calls the
> email
> > send routine.  Of course, that way the user will never know that there
> was a
> > bad address and that the report didn't go out.  So I think that's not a
> good
> > solution.
> >
> > However, is there a way to verify addresses before sending an email?  Or
> is
> > there a better approach to this problem?
> >
> > MTIA
> >
> > Rocky Smolin
> >
> > Beach Access Software
> >
> > 858-259-4334
> >
> > www.e-z-mrp.com <http://www.e-z-mrp.com/>
> >
> > www.bchacc.com <http://www.bchacc.com/>
> >
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>