Section 1: Overview and Email Setup
Section 2: A One Line VBA Command to Email a Report
Section 3: Replace the Orders by Date Macro from the Previous Course
-
Inspect the Macro and PrepXL Program from the Previous Course (9:00)
-
Create the PrepData Function and Test Entry of Dates (9:59)
-
Convert the First Two Queries to VBA (6:54)
-
Convert the Rest of the Queries and Test PrepData (15:49)
-
Fix an Error on the Last Query and Retest PrepData (8:15)
-
Add a Progress Bar and Turn On the Hourglass (8:05)
-
Two Ways to Get the Email from the Customer Table (9:10)
Section 4: Setup of Outlook Email Automation
Section 5: Using a Simple Emailer Database
-
Initial Inspection of the Finished Database (8:15)
-
Look at the VBA Code Behind Some of the Buttons (11:43)
-
Look at Code Behind Select Emails by Code and Send Email Buttons (10:47)
-
Using Word to Add Rich Text to the Email Body (7:19)
-
Introduction to Early and Late Binding (12:30)
-
A Second Example of Late Binding (2:42)
