A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

E-mail Merge



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2009, 09:40 PM posted to microsoft.public.access.reports
jb_tenor1
external usenet poster
 
Posts: 17
Default 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  
Old December 16th, 2009, 03:08 PM posted to microsoft.public.access.reports
Mark Andrews[_2_]
external usenet poster
 
Posts: 600
Default 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  
Old December 16th, 2009, 08:25 PM posted to microsoft.public.access.reports
jb_tenor1
external usenet poster
 
Posts: 17
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.