First, make an email group in Outlook with all the addresses that you want the mass mailing to go to.
Then, in Access, use the Docmd.SendObject method and specify the query or table as the object to send, the format to send it in (Excel would probably be the best) and the email group that you set up in Outlook.
If there is any better way, then please come up with a solution.
Discuss This Question: 4  Replies
do anyone have an answer to this? I'm looking for a similiar solution. I have a table with a email field. I want to send an email using SendObject in Macro but how to I import the email addresses from the table into the TO action argument?