Email recipients to receive 1 page of multi page report

[Guest]

I have 1 report that is several pages long. Each page contains information
that is to be emailed to a different recipient. I would like to be able to
automate this by having each email recipient receive only their page. Is
this possible?

Thanks in advance,
Connie

 

[Rick Brandt]

I have 1 report that is several pages long. Each page contains
information that is to be emailed to a different recipient. I would
like to be able to automate this by having each email recipient
receive only their page. Is this possible?

Thanks in advance,
Connie

Normally this would be handled by generating several instances (in sequence)
of the report with each having a filter applied so that the entire report
consists of just the page you want for each recipient.

 

[Guest]

Hi Rick. Thanks for your reply. I know I can filter the report, but
everytime I go in that direction, several scenarios arise that will prevent
it from working...efficiently that is. Do you know a way to filter the
report so that it will work in the manner I am looking for? The query is
sorted by Recipient ID, and in the report each page has specific info for
that recipient, but that is about the only simple thing about the query.
Because of the complexity of the query (it works with a lot of dates and has
to do some pretty specific stuff) I just want the one query and one report,
then I want to click the "Email" command button and each recipient to receive
their particular page. Not sure if it's possible, but would love to know if
there is some code that will loop through the query and check for email
addresses then send it to that address, or maybe there's a macro that will
make it work.

Thanks again

 

[Tony Toews]

I have 1 report that is several pages long. Each page contains information
that is to be emailed to a different recipient. I would like to be able to
automate this by having each email recipient receive only their page. Is
this possible?

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm