Course details
*** 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.
Updated on 27 December, 2017 - Read Less
