send report by email

[JHigh]

I have a report that “groups by customer ID†and produces each customer’s invoice/page and sends it out to the printer. I would like to do the same-but send out each invoice to that customer’s email address. Got any ideas? Thanks

 

[Bruce M. Thompson]

I have a report that "groups by customer ID" and produces each customer's
invoice/page and sends it out to the printer. I would like to do the same-but
send out each invoice to that customer's email address. Got any ideas? Thanks

See the following page at The Access Web:

http://www.mvps.org/access/reports/rpt0008.htm

 

[JHigh]

Don't know, but it may well be that the REPORT is not the way to handle thi
chore. We track our public radio station donors by their "pledge date" an
add 12 months to have a field for "renewal date. " When I run the query
looking for a renewal date, I can then produce a report--grouped by ID
which I then print out and put in the US Mail. Works great...but now we ar
getting listeners who want us to only use email. Not sure how best to handl
in Access

Got any ideas? Thank

 

[Mark Andrews]

You could write a routine to create PDF files and send emails with the PDF
attachment or
just build the body of the email from a query if you don't need the
sophistication of a report.

You could also build a web site which enables reports to be run off the live
data and send emails
out to customers pointing them to their link to run their report.

Basically "Push" vs. "Pull" methodology.

We sell two products one for each method,
Mark
RPT Software
http://www.rptsoftware.com

PS: We include an example of how to email customers their individual report
in the batch reporting
module.