How to set up an Access report to e-mail multiple clients their da

A

Anthony

In Microsoft Access I am trying to e-mail multiple reports out to multiple
customers. The customers should only see the information that is important to
them.
 
A

Arvin Meyer

Anthony said:
In Microsoft Access I am trying to e-mail multiple reports out to multiple
customers. The customers should only see the information that is important to
them.
Click to expand...

You'll need to write a query to print each report separately, or at least
print each customer's information on a separate page. As long as you can
identify each customer's report or page separately, you can loop through a
recordset and mail each one separately. A function to do that is at my
website:

http://www.datastrat.com/Code/MultipleEmail.txt

You will need to suppress the security messages which Outlook now uses to
block viruses from sending email. Check out a product called Redemption to
do that, or use a simple MAPI email program and adapt the code above.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
B

Brucels

I have had great success using WoldMerge (www.coloradosoft.com) to send
members dues statements which include their current Access database
information.

I have had similar success creating printed statements by using Word mail
merge. You can designate the fields from an Access table or query just as you
would in an Access report, but you have greater control over formatting. I
believe that the merge wizard also allows you to create merged email,
although I haven't use it for that purpose yet.
 
Top