E-mail Merge

  • Thread starter Thread starter jb_tenor1
  • Start date Start date
J

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