Access to Excel to Outlook: Email Excel & Access PDF Reports
4.7 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,214 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access to Excel to Outlook: Email Excel & Access PDF Reports to your Wishlist.

Add to Wishlist

Access to Excel to Outlook: Email Excel & Access PDF Reports

Learn to control Excel and Outlook from within Access! New section: How to Create PDF's of Reports & Email Instantly!
4.7 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,214 students enrolled
Last updated 5/2017
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 2 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create an Access Visual Basic Program that will Open and Update Excel from Access VBA then Email Excel files as Attachments Using Outlook.
  • Understand how to expand the power of VBA programming by linking to other Microsoft programs.
View Curriculum
  • The course files were created with Microsoft Office 2013, but Office 2007 or 2010 will also work with these techniques.
  • Knowledge of Access VBA is helpful, but not required, since every step of creating the program is fully documented.
  • Students who have not done any VBA programming may get a sense of the power and flexibility of VBA by taking this course.
  • This course is based on the database built in the previous course in the series "Access to Excel" and students will benefit greatly from taking that course before this one.

*** NEW SECTION Show How to Prep and Email Access PDF Reports ***

This new 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

PLUS the new section shows you how to Instantly create a PDF of any Access report (with a button on the report itself!) and email as an attachment! Learn More VBA Tricks!

This Course Uses Visual Basic, so if you have no experience with VBA you may find it confusing.  BUT every command and keystroke is demonstrated so, if you just duplicate what I do in the lectures, your program will work.  

This Course shows you. very quickly, how to use VBA programming to automate the distribution of Excel files by sending them as email attachments. By running one macro, you will update five reports in Excel, including a Pivot Table, then save and email the Excel file to as many email addresses as you have in your list. And all it takes is a few seconds!

From a Student -

"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 5 stars!" - Bare

The short programs we create in this course show you, step by step, how to update a link from Access to Excel using VBA, then save the Excel file and email it as an attachment by using Outlook, ALL under VBA control - all you do is enter the report dates you want and what you want to name the emailed Excel file!

* Videos show you every step of each process, including the setup of your email!

* There is no fluff and you can learn the entire method in about two 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

The method uses VBA Programming, but anyone with just a very basic knowledge of Access and Excel can easily accomplish all the tasks in the course, since every click and keystroke is shown and a finished copy of the program is provided. If you have never done any VBA programming, this could be a good way to get a general idea of how VBA works and the incredible power it gives you.

Think of how much time this will save you! Any reports you do on a regular basis can be setup with this method and you can save many hours every month!

Once you setup your data links and your email list, the process of distributing Excel reports by email only takes a few seconds and each email is personalized and sent to one email at a time.

And remember - you don't have to know anything more than the bare basics of Access and Excel to learn how to instantly send data from Access to Excel, then email the files using Outlook.

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 Microsoft Access tutorial 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 Microsoft Office 2013, but users of Office 2010 will still be able to complete the course. Note that data slices do not work on non pivot tables in Excel 2010, so there is a separate Excel file download for Office 2010.

Who is the target audience?
  • Anyone who wants to save a great deal of time by automating the distribution of Excel reports.
  • Students should have at least a general knowledge of both Access and Excel.
Compare to Other Microsoft Access Courses
Curriculum For This Course
42 Lectures
Overview and Email Setup
4 Lectures 12:57

In this lecture, I show you the Access and Excel files developed in the earlier course "Access to Excel- Instant Excel Reports and Excel Pivot Table". You will see how the Access macro uses the customer and order tables to create several reports that are linked to Excel. I will run the macro and show you the updated data in the Excel file, which has separate sheets for each of the five reports.

Preview 03:41

Create a Free Inbox.Com Email Account If Necessary

If you are not currently using Outlook, this lecture shows you how to set it up for use in sending emails from our Access VBA program.

Setup Outlook to Send Emails

Section 1 Notes
2 pages
Setup the Course Files and Update the Link to Excel
5 Lectures 13:02
Links to Course Files

Once you have downloaded the files, this lecture leads you through hands on testing of the Access macro and shows you the two tables used in sending the emails.

Preview 02:27

This lecture shows you how to update the link between the Access and Excel files that you have downloaded.

Update the Data Connection Between Access and Excel

OFFICE 2010 Data Connection Instructions

Section 2 Notes
2 pages
Create a VBA Function to Prepare the Excel File for Emailing
9 Lectures 34:24

This lecture leads you step by step in creating a new VBA module and function, then shows you how to link to the Excel and Outlook object libraries.

Preview 04:39

This lecture first reviews the tasks that we want the PrepXL function to accomplish, then saves the VBA program and reviews moving back and forth between Access and VBA..

Create a VBA Function that will Prep the XL File

In this lecture, each of the variables needed in the program are setup and discussed.

Setup Variables in the New Function

This lecture shows you how to verify that the Excel file exists and exit the function if it is not found.

Add VBA Code to Check Existence of Excel File

This lecture shows you how to ask for a new name for the copy of the Excel file, then create the copy.

Get the Send File Name and Copy the Excel file

Here we learn how to actually open Excel by opening the copy we just made, then refreshing the data. Once that is done, the data connections are removed and the file is saved.

Open Excel, Refresh Data and Remove Connections

Using the WAIT Function and Office 2010 Modifications
1 page

Now that the PrepXL function is complete, we create a macro to test it and run the macro.

Save and Test the PrepXL VBA Function

Section 3 Notes
4 pages
Create a VBA Function to Send the Email
9 Lectures 26:20

In this lecture we create a second function called DoEmail and setup the required variables.

Create the DoEMail VBA Function and Setup Variables

The next step is to open the EmailContent table and set variables for the Email Subject and Body.

Get the Email Subject and Body and Link to Outlook

In this lecture we open the EmailList table and create the loop to be used for sending emails.

Setup the Email List table and Our Loop

This lecture shows you how to do the first part of the loop by setting the email to, subject and body.

Setup the Message To, Subject and Body

This lecture shows you how to add the Excel file as an attachment and send the email message. We then move to the next record in the EmailList until we reach the end of the table.

Setup the Email Attachment and Send the Message

In this lecture we release the variables used and create a message that all emails have been sent.

Last Touches to Finish the DoEmail function

In this lecture we add the DoEmail function to the end of the PrepXL function and test the new program.

Test the Finished Email Function

Once the new function is tested, we add the PrepXL function to the end of the data macro and test creating a new set of data, updating Excel and emailing the attachments in a single process.

Preview 02:41

Section 4 Notes
4 pages
1 Lecture 00:44

This lecture provides an overview of what we have accomplished and mentions several new sections that will be added in the near future.

Final Overview and Future Additions
Email a PDF copy of a Report from the Report Itself!
13 Lectures 44:33
Download Link for This Section's Database
1 page

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
2 pages
Bonus Lecture - Learn Even MORE!
1 Lecture 08:29
Bonus Lecture - Expand Your Knowledge!
About the Instructor
Bruce Myron
4.6 Average rating
4,616 Reviews
46,489 Students
15 Courses
Productivity Specialist

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.

"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce

I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Billy Myron
4.7 Average rating
2,106 Reviews
16,063 Students
12 Courses
Udemy Instructor

Hello, my name is Billy. I was born and raised in the state of Oregon, and still live there.

On Udemy, I primarily assist Bruce Myron as an instructor on his courses. They deal with Microsoft Access, Microsoft Access VBA, and other Microsoft Office programs such as Excel.