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 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!
•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
•