Emailing multi reports

[Connie]

I would like to send a report via email. Each page of
the report contains information specific to a different
recipient, but each recipient should only receive their
page. Is this possible?

Also, as new recipients are added to the database, I
would like to have an automated process where the new
email is added to the email group.

Any help is most appreciated.

Connie

 

[Adam]

Hi Connie

Perhaps something like the following would work:

First of all, open the report using the DoCmd.OpenReport method, and specify
a where condition which limits the report to the specific page for the
recipient.

Then send the report to that recipient using the DoCmd.SendObject method.

You can loop through all your recipients in the same way.

HTH

Adam