Automate Emails From Excel VBA: Microsoft Outlook Mastery

Introduction
Introduction and Course Download Files
The Outlook Application Object
CreateItem Method and Item Types
BONUS - Troubleshooting Horribly Slow Code
Creating A New Email With CreateItem Method
Early vs Late Binding
Early vs Late Binding - Really Good Article
Set Up Your Own Constants To Soften Late Binding Blow
Our First Batch of Constants (For Your Convenience)
Conditional Constants To Streamline Declarations
Outlook Namespaces and How To Access Them
Sending An Email!
Creating A New Email Using GetDefaultFolder() [Late Binding]
olDefaultFolders enumeration List
Adding Recipients (Method 1)
Adding CC, BCC and Using With-End With (Method 1)
Set Importance, Read Receipt and Delivery Receipt Statuses
Add Subject & Body and Popup for Review!
Save Email as Draft Instead of Sending Right Away...
Tell Outlook To Send Email Later (Deferred Delivery)
Create a Quick Burner Email For Testing
Sending Our First Email Automatically
Stop Outlook Warnings That Halt Emails Being Sent
Send Using Alternate Sender Name
Better Method To Send With Alternate Account (Non-Primary Account)
Fun Email Tricks
Sending HTML Email And Easy Customization
Customize HTML With Outlook Trick
Free HTML Editor To Make Cool Looking Email Elements
Dealing With Large HTML Body
Dealing With Large HTML (Method 2 TXT File)
Adding A Simple Signature to Email
Adding The Default Signature to Email
Using A Different Signature
Accessing Outlook Folders by Name
Looping Through Items (Emails) In A Folder
Finding Specific Item With Find Method
Filtering Multiple Results Using Restrict Method
Does Outlook Folder Exist and Adding New Folders
Finding An Item By It's Unique Entry Identifier
Setting Default Inbox Folder For Loops
Search Emails Dynamically For Past Week or Last 30 Days
Advanced Filtering Using DASL Queries - Pt 1
Advanced Filtering Using DASL Queries - Pt 2 - Special Operators
Testing It Out And Determining If Instant Search Is Enabled
Easy Way To Instantly Discover DASL Syntax For Complicated Queries
DASL Filter Demonstration and More Concatenation Examples
DASL Reference Materials
Attachments & Personalized Emails With Excel Data
Open An Email Template File
Intro To Customizing with Auto Find and Replace
Sending A Custom Email to A Specific Row On Worksheet
Creating A Clickable 'Send Email' Column
Looping Through Excel Data With Customized Emails Pt 1 (Name Filter)
Looping Through Excel Data With Customized Emails Pt 2 (Date Filter)
Getting User Input and Assigning Buttons!
Generating One Email To An Automated List (To, CC or BCC)
Custom Function To Validate Email Addresses
Converting A Range To HTML and Placing In Email
Embedding A Range In Email Body Via Copy-Paste
Adding A Simple Attachment From File Path
Embedding An Image In Email Body
Custom Function For Random File Name
Attaching Worksheet To Email As PDF
Attaching A Single Sheet To Email
Attaching Entire Workbook To Email
Save Email Attachments To Specific Folder If It Doesn't Already Exist
Open Email Attachments And Gather Info Into Current Workbook!
Calendar Manipulation & Appointments
Calendar Items, Appointments and Meetings
Adding A New Appointment
Adding A New Meeting With Multiple Attendees (Recipients Method 2)
Duration Versus End Time!
DateAdd Function: Fun With Dates!
Determining Schedule Conflicts With Simple Math
Check If Proposed New Entry Has Schedule Conflicts with Restrict
Custom Reminders, Sound Files, Minutes Before Start, etc
Change Meetings With Bob To Red
Outlook Tasks
A Brief Overview of Outlook Tasks
Create A New Task
Assigning A Task To Someone
Looping Through Existing Tasks
Sending A Status Report For A TaskItem
Calculate Overdue Tasks; Auto-Email or Mark Complete Based on Task Ownership
Outlook Contacts
Create A New Contact
Other Contact Fields of Interest
Quickly Set Contact Object Using FullName
Check If Worksheet Contact Exists Before Adding
Iterate Through Contacts and Put Them In Excel Sheet!
Fill Userform ListBox With Outlook Contacts
Edit Contact Selection From Userform ListBox
Send Email To Selected Userform ListBox Contact!
Other Outlook Tricks
Accessing Important Hidden Collections & Putting Into ComboBoxes
Automatically Find Buried Folder Recursively - Custom Function
Previous Lesson
Next Lesson

Creating A New Email With CreateItem Method

Automate Emails From Excel VBA: Microsoft Outlook Mastery Creating A New Email With CreateItem Method
Previous Lesson
Back to Course
Next Lesson
2 Comments
Collapse Comments
Linag August 29, 2023 at 11:40 pm

LMAO! Dan...you ain't hiding your gmail addy with that blur edit at the end of the lecture LOL :D:D:D

Dan Strong (Administrator) August 31, 2023 at 8:11 am

Haha! True that. I'd much prefer people hit me up at my dan@excelvbaisfun.com email these days, but no worries if they use that one. I just get so much spam it's hard to sift through it to find real messages 🙂
Thanks, Lina

Leave a Comment

X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram