If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
E-mail Merge
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? |
#2
|
|||
|
|||
E-mail Merge
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" wrote in message ... 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? |
#3
|
|||
|
|||
E-mail Merge
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/emai...recipients.htm http://www.granite.ab.ca/access/email/recordsetloop.htm http://support.microsoft.com/?kbid=209560 Jeff "Mark Andrews" wrote: 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" wrote in message ... 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? . |
Thread Tools | |
Display Modes | |
|
|