Sending Group E-mails from Access

B

Blue nose

Can anybody tell me how to set up a macro in Access that will automatically
load a number of addresses from an Access Form in to the To box in outlook. I
have managed to find the macro SendObject but cannot understand how to set up
group e-mail.
 
B

Bob

You can go to: datastrat.com and look for a download
called EmailSenate for an example for group emails.

If you already have a group setup in your address book and
the email will always go to the same group, you can just
type the group name in the "To" box when you setup the
SendObject action in your macro.
 
A

Arvin Meyer

Blue nose said:
Can anybody tell me how to set up a macro in Access that will automatically
load a number of addresses from an Access Form in to the To box in outlook. I
have managed to find the macro SendObject but cannot understand how to set up
group e-mail.
Click to expand...

This database is a sample for sending multiple reports to multiple
recipients:

http://www.datastrat.com/Download/EmailSenate2K.zip


and this code will do something similar in Outlook with any attachment (not
just an Access object):

http://www.datastrat.com/Code/MultipleEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
B

Blue nose

The database I have set up is a contact list with an e-mail field I have a
search facility that will produce a nominal roll based on the search
criteria, I would like to be able to e-mail everybody on that nominal roll,
and with over 200 people on the list it is time consuming and changes
dependant upon the search criteria. Can yuo help.
 
Top