Microsoft Access 365: Access VBA & Automating Outlook Email

Learn more about Microsoft Access VBA and using VBA to send Outlook emails from within Microsoft Access!

Created by: Bruce Myron
Productivity Specialist

What Will I Learn?

• Create an Access Visual Basic Program that will use a one line command to Email a Report as an Attachment
• Understand how to user VBA to open and control the Microsoft Outlook email program and send emails to multiple recipients.
• MANY time saving VBA techniques, not just those used with Email, are explained in detail.

Requirements

• The course files were created with the latest (as of June 2020) version of Microsoft 365 Office so it is recommended that students use this version.
• This is an INTERMEDIATE Course and Basic Knowledge of Access VBA is required.
• Students who have not done any VBA programming may get frustrated because I assume they know the basics and I move faster than in the first VBA course.
• This course is based on the database built in the previous course in the series "Microsoft 365 Access: Link Data to Excel with Macros and VBA" and students will benefit greatly from taking that course before this one.

Target audience

• Anyone who wants to save a great deal of time by automating the distribution of Excel reports.
• Students with a basic understanding of Access VBA that would like to see examples of how to use it to increase productivity.