Emailing reports from Access

[rmorrison]

Hi, I have a scheduling database for audits and auditors. I need to be
able to email auditors their schedule each week, based on a query on
the audit table. How do I automate sending auditors their individual
reports by using one report? I can run the report which shows the
auditors with their respective audits on each page (1 page per
auditor), but to email it, I have to convert it to pdf (so they can't
change it) and insert each page of the report manually.

Thanks

 

[Tony Toews [MVP]]

Hi, I have a scheduling database for audits and auditors. I need to be
able to email auditors their schedule each week, based on a query on
the audit table. How do I automate sending auditors their individual
reports by using one report? I can run the report which shows the
auditors with their respective audits on each page (1 page per
auditor), but to email it, I have to convert it to pdf (so they can't
change it) and insert each page of the report manually.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/