How to Auto Email Access Reports

Microsoft Access is a powerful, consumer-friendly database program. It can be used for individual households and for businesses. Some components of the database include tables, queries, forms, reports, macros and modules. Reports provide an easily readable presentation of the information in the database. Macros allow routine tasks to be automated. Reports can be shared via email and sent automatically.

...
Auto Email Access Reports

Step

Go to "Start" > "Programs" > "Microsoft Office" > "Microsoft Access," or if Access has been opened recently, go to "Start" > "Microsoft Access."

...
...

Step

Select a database to use. In this case, the Issues database is downloaded.

...

Step

Click on the "Create" tab.

...

Step

Click on "Macro."

...

Step

Select "Send Object" in the Action drop-down box.

...

Step

Complete each of the steps in the Action Argument. Select "Report" for the Object Type, select "Open Issues" for the Object Name (this is the name of the report that will be emailed) and select "PDF Format (*.pdf)" for the Output Format. Enter the email addresses of the report recipients, the Subject of the email and the text for the body of the email (Message Text). If the email message needs to be edited before being sent, select "Yes"; otherwise select "No." For HTML files, provide a path for the template.

...

Step

Click on the disk icon to save the macro.

...

Step

Name the macro, then click "OK."

...

Step

Click the exclamation point to run the macro. The program will request that the macro be saved once again.

Step

Click on "Allow" to permit the program to send the email. The reports will be sent via Outlook.

Step

Open the Navigation Pane by clicking on the double arrows.

Step

Double-click the saved macro to automatically email the report.

Step

Open the email to verify that it was sent.