Emailing reports from Access

R

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
 
T

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top