[AccessD] Email Problem

Thanks Stuart.  That may be the answer. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, September 22, 2008 3:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Email Problem

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