Access/Email

[Susan]

I have a table of 'Clients' and want to send to send one
email to all of them (like bulk emails using my email
address field in Access 2000). We use MSOutlook 2000.

Does anyone know of a way to do this? Thank you.

 

[Sandra Daigle]

Lots of good articles on how to do this:

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

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Outlook for the Summer (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm

 

[Didier]

Hello,

In a basic code program: just read your email addresses
from your table one by one and use DoCmd.SendObject to
send email one by one.
Hope this helps.
Fo more info in Access help search for SendObject and you
will find examples.

Didier