How to Auto Email Access Reports

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
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.

Advertisement

Step 1

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

Advertisement

Video of the Day

Step 2

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

Advertisement

Step 3

Click on the "Create" tab.

Advertisement

Step 4

Click on "Macro."

Advertisement

Advertisement

Step 5

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

Advertisement

Step 6

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.

Advertisement

Advertisement

Step 7

Click on the disk icon to save the macro.

Advertisement

Step 8

Name the macro, then click "OK."

Advertisement

Step 9

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

Advertisement

Step 10

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

Step 11

Open the Navigation Pane by clicking on the double arrows.

Step 12

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

Step 13

Open the email to verify that it was sent.

Video of the Day

Advertisement

Advertisement

resources