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.
Software/Hardware used:
ASKED:
April 29, 2008 12:42 PM
UPDATED:
October 4, 2008 8:54 PM
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?
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.
Hi, I am having the exact same problem, I am loking for an easy way to use email address from a query to send out a mass email. Is there an easy way to do this, and if possible could you show an example..
Ideally it would be great is is it was possible to put something inot the TO field of the SendObject Macro.
Any ideas??