e-mailing sections of a report to specific e-mail addresses

  • Thread starter Thread starter tj
  • Start date Start date
T

tj

Bear with me here... this is complicated... at least it
is for me... using Access 2003...

I have a transaction table that contains a field
called "APPROVER" which is an e-mail address of the
person assigned to approve the transaction...

I query the table to collect and summarize all the
transactions for that "APPROVER"... from the query I
create a report that page breaks by "APPROVER" and I want
to e-mail the section of the report to them
automatically...

"Merging" the report to Word isn't an an option in Access
and even if it were, the e-mail addresses from the
query/report don't go with the file...

Is there some way of doing this simply and easily ???
Using a "send to" macro will send the whole report, but I
just want them to have the part that belongs to them...

Let's have a discussion on this...

Thanks... tj
 
You need to run a separate report for each approver and email it. You could
build a form based on a query of all active approvers. Have a loop that
runs the report with a filter, sends it, advances the calling form to the
next user, and repeats the process. We do this with a Work-In-Process that
we email to each of our 60 employees every Thursday.

Once in a while, it will send the wrong report to a person. It kinda 'gets
ahead of itself'. We have inserted code to pause at various points, and
this seems to have helped, but if the report is very sensative, you might
not want to use this.

Also, you CAN publish a report to MSWord.


Rick B


Bear with me here... this is complicated... at least it
is for me... using Access 2003...

I have a transaction table that contains a field
called "APPROVER" which is an e-mail address of the
person assigned to approve the transaction...

I query the table to collect and summarize all the
transactions for that "APPROVER"... from the query I
create a report that page breaks by "APPROVER" and I want
to e-mail the section of the report to them
automatically...

"Merging" the report to Word isn't an an option in Access
and even if it were, the e-mail addresses from the
query/report don't go with the file...

Is there some way of doing this simply and easily ???
Using a "send to" macro will send the whole report, but I
just want them to have the part that belongs to them...

Let's have a discussion on this...

Thanks... tj
 
Back
Top