Emailing Addresses from a Query

[citloner]

Hello,

I have a list of email addresses from a query that I want to automatically
email from Access to Outlook. I tried creating a macro using "Send To" but
it just sends to one email address and attaches the query. How do I send to
the email addresses in the query directly? I don't want to have to cut and
past all addresses! I am not an Access guru. Could you please tell me there
is an easy way to do this?

Thanks,
Citloner

 

[tina]

well, i don't know how to do it using a macro. if nobody else can help you
with that, post back if you'd like a solution that uses VBA code instead. i
actually posted an answer to this same question in another thread today:
http://groups.google.com/group/micr...a/54e608130a8793ac?lnk=st&q=#54e608130a8793ac

hth

 

[pietlinden]

Hello,

I have a list of email addresses from a query that I want to automatically
email from Access to Outlook.  I tried creating a macro using "Send To"but
it just sends to one email address and attaches the query.  How do I send to
the email addresses in the query directly?  I don't want to have to cutand
past all addresses!  I am not an Access guru.  Could you please tell me there
is an easy way to do this?

Thanks,
Citloner

You can't really do this using macros. They're just too limited.
You can do it by opening a recordset off the query and then automating
Outlook to send the e-mail to everyone on the recordset. (The
recordset is just the bunch of records "described by" the query). Is
there an easy way to do this? If you think VBA is hard, then No.
In your code you would have to do something like this:
1. create a new message in Outlook
2. set the Subject and Body properties of the message
3. attach all the attachments you want.
4. loop through the recordset of recipients adding them to the
Recipents collection of the message.
5. send the message
6. clean up.