Automatically Email Access Reports

L

Lisa

I am trying to figure out how to automatically send an access report daily to
one person. Is there a way to do this and if so some instructions on how.

Thanks.
 
D

Damian S

Hi Lisa,

Use the following to email the report:

docmd.SendObject acSendReport, "REPORT_NAME", acFormatSNP, "TO_FIELD",
"CC_FIELD", "BCC_FIELD", "SUBJECT_HERE", "MESSAGE_BODY", false

The tricky part is automating it... you could always have an on open event
in the database that checks if the report has been mailed (by placing a date
into a table) and if not, mail the report and update the date.
Alternatively, simply have the code behind a button.

Hope this helps.

Damian.
 
Top