send report by email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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.
 
Don't know, but it may well be that the REPORT is not the way to handle this
chore. We track our public radio station donors by their "pledge date" and
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 are
getting listeners who want us to only use email. Not sure how best to handle
in Access.
Click to expand...

This might be a little tricky, as you'll need to generate a snapshot file (or
other type of file, depending on how you decided to go) for each listener.
You'll need to add a field to the "Listener's" records to identify their
preference for receiving notices (if you haven't already) and two versions of
the report's recordsource query for the report, each to filter records based on
their preference (in all other respects, the queries would be identical to the
existing one). If you are opening/running your reports from a form, you can
assign the report's recordsource query in the *report's* "OnOpen" event
procedure according to a selection made on that form (option group?).
 
Back
Top