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!

4.60 (229 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
2,754
students
3 hours
content
Nov 2023
last update
$59.99
regular price

What you will 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.

Description

This review says it all:

"This is the best Udemy class I've taken so far. The only thing better than learning by doing is to learn to do something USEFUL. This class teaches you a useful skill (email Excel reports) but it also shows you how easy and powerful VBA can be. It only took about 3 hours to gain useful knowledge of Excel, Access and VBA. Good audio/video quality plus example files and detailed PDF instructions. We need more like this!!" - Russ Cannizzo

This is an INTERMEDIATE Microsoft Access VBA Course and you should take the "VBA for Non-Programmers" course, or the equivalent, before taking this one.  This course builds on the Macro and VBA code created in the course "Microsoft Access 365: Link Data to Excel with Macros and VBA" so it is recommended that you also take that course before this one.  In the course I assume you already know how to create Access VBA functions and subroutines and I move more quickly when creating VBA Code.  

This shows you several ways to use Access VBA to automate the distribution of Excel files by sending them as email attachments.  We learn how to send Access objects as attachments with a one line command, then we replace the multiple query update macro created in the previous course with VBA Code.  We then learn how to control Outlook and send emails to multiple recipients.  We conclude by examining the VBA techniques used in a simple, yet powerful, Emailing database.

From a Student -

"This course is amazing, I thought that was more difficult to create a program to send emails from Access, but not really! Bruce's explanation makes the things easier to understand, he is an extremely good teacher, an expert in this topic. I have taken several of his courses and when I finished I have the feeling of wanting to learn more, I've definitely will continue my learning of Access with his courses, I recommend his courses a lot, very useful and interesting." - Roberto Carlos Huerta Gomez

In short, to the point videos, you will learn MANY new Access VBA techniques that you will use for years to come!  This course is a great followup to the first VBA course in that it shows you the best way to use VBA to automate many common tasks, not just emailing.

* Videos show you every step of each process!

* There is no fluff and you can go through the entire course in a few hours!

From another Student -

"I'm little rusty on VBA skills yet the instructor has explained the needed commands in a way I would listen to him for hours. And files are downloadable too so I know where to return when my business clients need this great automation." - Matt S Rinc

Anyone with a solid understanding of the basics of Access VBA can easily accomplish all the tasks in the course, since every click and keystroke is shown and a finished copy of the database is provided.  This is a great way to expand your VBA skills and discover more of the incredible power available with Access programming.

Think of how much time this will save you!  Emailing from Access will be SIMPLE for you and you can save many hours each month!  You will be able to control data in subforms in ways you did not know possible!

Another Student -

"Excellent teaching style with easy to understand explanations. Bruce is excellent when it comes to responding to queries, and is happy to hear any ideas you may have to improve (and expand) the course. Buy it!!!" - Ray McConaghy

This course could greatly increase your productivity and help you develop skills that are in very high demand in the workplace.

Click the Take This Course button and start learning right now!

NOTE: The course files were created using the latest version of Microsoft 365 Office so versions prior to  2013 may not function properly.  If you have one of these earlier version, I strongly urge you to setup a subscription to Microsoft 365.  It is low cost and you can update multiple computers with the entire Office suite with a single subscription.

Content

Overview and Email Setup

Introduction and Overview of Files
Create a Free Inbox.Com Email Account If Necessary
Setup Outlook to Send Emails
Section 1 Notes

Setup the Course Files and Update the Link to Excel

Links to Course Files
Test the Access Macro and Setup the Email List
Update the Data Connection Between Access and Excel
OFFICE 2010 Data Connection Instructions
Section 2 Notes

Create a VBA Function to Prepare the Excel File for Emailing

Create a New VBA Module and Link to Excel and Outlook References
Create a VBA Function that will Prep the XL File
Setup Variables in the New Function
Add VBA Code to Check Existence of Excel File
Get the Send File Name and Copy the Excel file
Open Excel, Refresh Data and Remove Connections
Using the WAIT Function and Office 2010 Modifications
Save and Test the PrepXL VBA Function
Section 3 Notes

Create a VBA Function to Send the Email

Create the DoEMail VBA Function and Setup Variables
Get the Email Subject and Body and Link to Outlook
Setup the Email List table and Our Loop
Setup the Message To, Subject and Body
Setup the Email Attachment and Send the Message
Last Touches to Finish the DoEmail function
Test the Finished Email Function
Add the Function to the Macro and Do the Final Test
Section 4 Notes

Conclusion

Final Overview and Future Additions

Email a PDF copy of a Report from the Report Itself!

Download Link for This Section's Database
Overview of the New Database
Modify the Do Invoice Button
Fix Problem with Subtotal on Report
Create a Close Button on the Report
Create an Email Invoice Button
Create a New Subroutine to Create the PDF File
Test the PDFName and Get the Email Address
Create the PDF File and Test the Subroutine
Create a New Subroutine to do the Email
Finish the Email Subroutine
FInal Touches and Testing
PDF of Our Two Subroutines

Bonus Lecture - Learn Even MORE!

Bonus Lecture - Learn Even More!

Screenshots

Microsoft Access 365: Access VBA & Automating Outlook Email - Screenshot_01Microsoft Access 365: Access VBA & Automating Outlook Email - Screenshot_02Microsoft Access 365: Access VBA & Automating Outlook Email - Screenshot_03Microsoft Access 365: Access VBA & Automating Outlook Email - Screenshot_04

Reviews

Gene
September 19, 2023
Bruce went to fast for me to understand all that he was doing. Probably I going to watch the video a few time to understand it.
Alexandra
April 20, 2021
Always get great info from Bruce's Courses. In the last 6 months I have learned how to write VBA code to completely build programs to run my business from these courses. The skills Bruce teaches continue to grow and you will be able to figure out how to do anything automatically. As long as you put in the effort and time to learn!
Paul
January 3, 2021
De cursus gaat heel snel vooruit met een volledig voorbereide Access Database. Voor beginners is dit niet eenvoudig om te volgen. Het zal dus wel nodig zijn om de cursus meerdere keren te doorlopen in enkele stappen. De lesgever heeft er al heel wat ervaring opzitten vooraleer hij de cursus vorm heeft gegeven. Zoveel is duidelijk.
Keith
June 30, 2016
A lot to learn but the clearly explained steps within short lectures makes this course understandable and memorable. This knowledge significantly increases productivity through automation. Highly recommended!
Chase
June 29, 2016
I'd give it a five if I could interactive with someone in regards to questions on specific things. I'm working with a database base that I didn't entirely setup which leads to a lot of specifically minded questions and problems. However the course itself is well done and bruce clearly likes what he does.
Amanda
March 27, 2016
This course has expanded what little knowledge I have about VBA. The terms and code structure is becoming more and more clear. I am starting to anticipate what the next step is and notice errors more readily. In addition, learning how to harness the connectivity in Microsoft products is going to be incredibly useful.
Scott
March 27, 2016
Excellent Course Bruce! I cant tell you how I wish I had found these courses long ago. You would have saved me much head banging on the walls! -S
Christopher
March 22, 2016
This course was just right for me. I had the obstacle of emailing and it opened that door very wide. Awesome pace for the somewhat experienced person with great clear instructions and notes.
Rodney
March 15, 2016
Again, I have taken several of Bruce's courses. I would take this course 3rd in his series. They ll build on the previous course to establish a solid foundation in Access. I can't say enough about how great this series on Access is and how interfacing it with other office applications like Excel and Outlook can improve productivity and overall function of any database. This is the real deal and it utilizes real world data and real situations you will need to apply. Enjoy it.
Ray
February 21, 2016
Excellent teaching style with easy to understand explanations. Bruce is excellent when it comes to responding to queries, and is happy to hear any ideas you may have to improve (and expand) the course. Buy it!!!
Tonie
January 2, 2016
Exact content I need to finish my new project. The Instructor is very clear and detailed, the video is easy to read and files with code are provided for our use. And now I understand how to email from Access. Thanks!
David
August 25, 2015
The content is good like the name says The delivery of the course is very informative The course covers very good every day items but has future room for expansion to allow different types of files to be sent instead of just Excel files - Like PDF Files of Invoices, Statements, Lists etc... Looking forward to additions to this course Thanks Bruce!
Russ
August 25, 2015
This is the best Udemy class I've taken so far. The only thing better than learning by doing is to learn to do something USEFUL. This class teaches you a useful skill (email Excel reports) but it also shows you how easy and powerful VBA can be. It only took about 3 hours to gain useful knowledge of Excel, Access and VBA. Good audio/video quality plus example files and detailed PDF instructions. We need more like this!!
Bare
May 30, 2015
This is a follow up course from Bruce's Access to Excel & Access VBA. No disappointments in his now family consistent style of teaching - simple, clear, & right to the heart of its real world application! I'm giving it a 5 because it follows on what I already know from the previous courses & my knowledge of VBA. You will enjoy the course like I did if you have basic to mid level understanding VBA & gone through Bruce's other courses on VBA and Access to Excel. If you haven't (though I strongly suggest you do), not a problem. Have an open mind and follow along - absolutely no way for you to get lost in any maze!
Matt
May 20, 2015
I'm little rusty on VBA skills yet the instructor has explained the needed commands in a way I would listen to him for hours. And files are downloadable too so I know where to return when my business clients need this great automation.

Charts

Price

Microsoft Access 365: Access VBA & Automating Outlook Email - Price chart

Rating

Microsoft Access 365: Access VBA & Automating Outlook Email - Ratings chart

Enrollment distribution

Microsoft Access 365: Access VBA & Automating Outlook Email - Distribution chart

Related Topics

482854
udemy ID
4/22/2015
course created date
11/22/2019
course indexed date
Bot
course submited by