| 1. Bonus Lecture - Learn Even More!.html | 716.8 B | ||
| 1. Create the DoEMail VBA Function, Setup Variables and add an error trap.mp4 | 126.2 MB | ||
| 1. Create the DoEMail VBA Function, Setup Variables and add an error trap.srt | 11 KB | ||
| 1. Create the New Do Invoice Subroutine.mp4 | 159.1 MB | ||
| 1. Create the New Do Invoice Subroutine.srt | 15.6 KB | ||
| 1. Initial Inspection of the Finished Database.mp4 | 123.9 MB | ||
| 1. Initial Inspection of the Finished Database.srt | 11.3 KB | ||
| 1. Inspect the Macro and PrepXL Program from the Previous Course.mp4 | 126.4 MB | ||
| 1. Inspect the Macro and PrepXL Program from the Previous Course.srt | 12.9 KB | ||
| 1. Introduction.mp4 | 77.9 MB | ||
| 1. Introduction.srt | 7.5 KB | ||
| 1.1 EMailer.accdb | 970 KB | ||
| 1.1 OrderDataVBA.accdb | 2.3 MB | ||
| 1.2 OrderDataVBADONE.accdb | 2.3 MB | ||
| 1.3 SalesReport.xlsx | 518.8 KB | ||
| 2. Create an Email Button and Subroutine.mp4 | 128.8 MB | ||
| 2. Create an Email Button and Subroutine.srt | 12.6 KB | ||
| 2. Create the PrepData Function and Test Entry of Dates.mp4 | 131.5 MB | ||
| 2. Create the PrepData Function and Test Entry of Dates.srt | 13.8 KB | ||
| 2. Get Email Subject and Body and finish the DoEmail function.mp4 | 113.7 MB | ||
| 2. Get Email Subject and Body and finish the DoEmail function.srt | 11.7 KB | ||
| 2. Important NOTE on DOWNLOADABLE RESOURCES.html | 512 B | ||
| 2. Look at the VBA Code Behind Some of the Buttons.mp4 | 175.1 MB | ||
| 2. Look at the VBA Code Behind Some of the Buttons.srt | 17.9 KB | ||
| 3. Convert the First Two Queries to VBA.mp4 | 95.4 MB | ||
| 3. Convert the First Two Queries to VBA.srt | 10.1 KB | ||
| 3. Create the Call to the DoEmail program and Test.mp4 | 125.2 MB | ||
| 3. Create the Call to the DoEmail program and Test.srt | 12 KB | ||
| 3. Look at Code Behind Select Emails by Code and Send Email Buttons.mp4 | 156.2 MB | ||
| 3. Look at Code Behind Select Emails by Code and Send Email Buttons.srt | 15.6 KB | ||
| 3. Test the One Line Email Command.mp4 | 83.1 MB | ||
| 3. Test the One Line Email Command.srt | 8.7 KB | ||
| 4. Convert the Rest of the Queries and Test PrepData.mp4 | 230.3 MB | ||
| 4. Convert the Rest of the Queries and Test PrepData.srt | 19.1 KB | ||
| 4. Correct a Few Errors.mp4 | 50.3 MB | ||
| 4. Correct a Few Errors.srt | 4.9 KB | ||
| 4. Download of Database Used in Next 3 Videos.html | 307.2 B | ||
| 5. Figure Out Why the Dates are Wrong on the Excel File.mp4 | 142.4 MB | ||
| 5. Figure Out Why the Dates are Wrong on the Excel File.srt | 12.8 KB | ||
| 5. Fix an Error on the Last Query and Retest PrepData.mp4 | 119.7 MB | ||
| 5. Fix an Error on the Last Query and Retest PrepData.srt | 11.5 KB | ||
| 5. Using Word to Add Rich Text to the Email Body.mp4 | 104 MB | ||
| 5. Using Word to Add Rich Text to the Email Body.srt | 10.4 KB | ||
| 6. Add a Progress Bar and Turn On the Hourglass.mp4 | 113.8 MB | ||
| 6. Add a Progress Bar and Turn On the Hourglass.srt | 11 KB | ||
| 6. Introduction to Early and Late Binding.mp4 | 180.5 MB | ||
| 6. Introduction to Early and Late Binding.srt | 17.9 KB | ||
| 7. A Second Example of Late Binding.mp4 | 41.2 MB | ||
| 7. A Second Example of Late Binding.srt | 3.6 KB | ||
| 7. Two Ways to Get the Email from the Customer Table.mp4 | 130.4 MB | ||
| 7. Two Ways to Get the Email from the Customer Table.srt | 13.1 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 53 total files | |||
Microsoft Access 365: Access VBA & Automating Outlook Email
https://DevCourseWeb.com
Last updated 11/2023
Created by Bruce Myron
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 25 Lectures ( 3h 12m ) | Size: 2.67 GB
Learn more about Microsoft Access VBA and using VBA to send Outlook emails from within Microsoft Access!
What you'll 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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 13 hours | 0 | 0 | |
| 2.2 GB | freecoursewb | 1 week | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 week | 1 | 11 |
| 999.5 MB | freecoursewb | 1 week | 0 | 0 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 week | 2 | 56 |
All Comments