e-mail report

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

Guest

I have produced a report in sorted by manager with a new page per manager but
now they wish to receive their part of the report by e-mail.

I presume that I will need to create a file per manager then e-mail the
managers from a contacts table set up.

How can I do this?

Thanks for any help
Graham
 
Graham said:
I have produced a report in sorted by manager with a new page per manager
but
now they wish to receive their part of the report by e-mail.

I presume that I will need to create a file per manager then e-mail the
managers from a contacts table set up.

How can I do this?

Thanks for any help
Graham
Click to expand...
 
Graham:

Most of Access' built in methods to output a report to a file (e.g. an RTF
File, or a Snapshot file) don't easily lend themselves to filtering a report
one page at a time. The easiest way is to use a PDF creator which works
like a printer so that rather than using the OutputTo method (no filters)
you can use the OpenReport method, which does allow filters. The next
challenge of course is to uniquely name the file which you can do manually
when the report is created from the displayed file save as dialog the driver
would normally display.

If you want to automate this whole process, you'd need both a suitable PDF
creation driver and either to program that driver (some support it and some
don't easily), or use an intermediate library like our PDF and Mail library
which would allow you to use any number of inexpensive drivers like Win2PDF
to create the unique report and then mail them, automatically, with modest
programming. You'll find it on our web.
 
Back
Top