E-mail Merge

[jb_tenor1]

I have a report that is using a subreport, which I would like to then
leverage through e-mail merge. The Report has customer information in the
top, including the e-mail address and then product information in the
subreport as it pertains to the customer. Each page contains the unique
customer along with their e-mail address, and I want to automate e-mails
going to each of those e-mail addresses so that I don't have to do them one
at a time. How do I go about doing this?

 

[Mark Andrews]

In general use a recordset and some code to loop through the records and for
each one:
- construct the email (using strings for body, to, from etc...)
- send the email
if you want to send the report as an attachment either save it to disk as a
pdf (using whatever method you like to make the pdf) and then attach it to
the email or use the built-in docmd.sendobject to send the email with report
attachment.

My product and source code if you need help:
http://www.rptsoftware.com/products/email/

Here's the other page most people point at for general email help:
http://www.granite.ab.ca/access/email/index.htm

Hope that helps get you started,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[jb_tenor1]

Thanks! I managed to find one of the pages you linked below just a little
earlier this morning. If anyone else searches for this functionality, I'm
including additional links I found to help with this as well:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

http://www.granite.ab.ca/access/email/recordsetloop.htm

http://support.microsoft.com/?kbid=209560

Jeff