Question

  Asked: Apr 29 2008   12:42 AM GMT
  Asked by: Itguy1509


MS ACCESS 2007 mass email list?


Microsoft Office 2007, Access 2007, Microsoft Access, Outlook, Mailing lists

I was wondering is there a way to create a mass email from a query or table that would send out in MS OUTLOOK?

I know of a way of extracting a table and importing it into OUTLOOK but my boss wants a more efficient way.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Microsoft Windows, Database and Exchange.

Looking for relevant Microsoft Windows Whitepapers? Visit the SearchWinIT.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Itguy1509  |   May 1 2008  1:43PM GMT

the method that my boss is looking for is a simple button that he clicks and everything is done for him all he has to do is press send /or write a message. The most important part is that the i get email addresses to auto fill from the database into the compose message.

any help?

 

Randym  |   May 2 2008  1:40PM GMT

If you don’t want to use the email group that I mentioned, you could have a field in a table with all the addresses separated by ; and place that into the [TO] parameter of the sendobject method. Or, if you have a table of addresses, you could load a string by looping through a recordset of the table and once you have the string built, place that into the [TO] parameter.