Mass Email

[Basia]

Greetings. I have set up a email system in Access 2000 to loop through a recordset and send each record a personalized email. Two problems:

1) I have the email function set up on a command button. When I click the command button, it sends out the email. If I leave the form and come back, the command button does not work. Any ideas?

2) Since we could be sending hundreds of emails at a time, I do not want the verification window to pop up for each email. Is there a way to suppress the "Program is trying to automatically send an email on your behalf. Do you want to allow this?"

Thanks in advance

 

[tlbroadbent]

1) I assume you are using SendObject to send the Email. I've encountered the same problem when attempting to send mail again in the same session. My solution was to use Outlook objects. You can do the same if you use Outlook as the email client. Download code for an "Access 2000 SendMessage Function" from my web site.

http://tlbroadbent.home.attbi.com/prog.htm

2) The message, "Program is trying to automatically send an email on your behalf. Do you want to allow this?" is the result of Microsfot's security efforts. See the following Knowledgebase articles.

http://support.microsoft.com/support/kb/articles/Q263/0/84.ASP

http://support.microsoft.com/support/kb/articles/Q262/9/97.ASP

http://support.microsoft.com/support/kb/articles/Q263/4/44.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.