Can I email all the email addresses in my access database file in a easy way using the program?

I have created a database file in access will a number of email addresses. Is there a way to email all people in the database with the same email using the program to make it easier?


Thank You
Can I email all the email addresses in my access database file in a easy way using the program?
Depends on your email software. I have done what you are wanting to do using MS Outlook. What you have to do is access the object model of MS Outlook. create the message then loop thru the email addresses sending the message out for each address.





It won't work if your using a web-based email.
Reply:Create a vba routine to concatenate the addresses, subject etc via a query then use the DoCmd.SendObject method
Reply:if you use Outlook you will use the MAIL MERGE function.


I do this and it works great as I can send a bulk email but it uses the persons name in the body of the message so it looks like it is personel


Dear %26lt;NAME%26gt; is the format
Reply:The way I'd do it is to simply put a tick next to all the people I want to send to, then create one message %26amp; hit "SEND".