How do I create an Access mail merge email blast using a query?

[Guest]

I have a query of data in Access and would like to create an merge to send
out an email blast to my customers with their data in the email to them. I
am not sure how to do that. Help?

 

[Tony Toews]

I have a query of data in Access and would like to create an merge to send
out an email blast to my customers with their data in the email to them. I
am not sure how to do that. Help?

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator character, such as comma or
semi-colon, and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

I have a query of data in Access and would like to create an merge to send
out an email blast to my customers with their data in the email to them. I
am not sure how to do that. Help?

Whoops, my previous posting was for sending the identical email to
multiple recipients.

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.htm.

Tony




--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm