Emailing Addresses from a Query

  • Thread starter Thread starter citloner
  • Start date Start date
C

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
 
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
Click to expand...

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.
 
Back
Top