sending mail?

  • Thread starter Thread starter John Do
  • Start date Start date
J

John Do

I want to send 150 emails to 150 different persons. The text will be the
same, but the attachement is personal. How can this be done bij acces. I
have the text, the adresses and te location and name from the attechements
in an excel file. How can i send these mails without doing it by hand.

Bert
 
Create a linked table in an Access database. Then create a procedure which
opens a recordset on the table and loops through the recordset building and
sending the emails - here are some articles which demonstrate a) How to
create and send an email b)How to loop through a recordset to create and
send email.

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm
Sample Code illustrating looping through a DAO recordset
http://www.granite.ab.ca/access/emailsend.htm
 
Hi,

This can be done programmatically.
You can use MS Outlook, but due to its security restrictions, it prompts you
when another program (like Access) try to send e-mail, and you might need
to wait few seconds, then click a button for every mail.

This isn't a very convenient way for sending 150 e-mails

Another way is to use a 3'ds party ActiveX SMTP ActiveX control. With it,
you'll bypass Outlook security restrictions, and send mail directly to your
internet mail server. This is the fasters and most reliable way to
accomplish what you need

If you need more details or help, you can contact me directly.

HTH,
Bogdan Zamfir
_______________________

Independent consultant
 
Back
Top