LEARNING PATH
- Introduction and Course Download Files
- The Outlook Application Object
- Create Item Method And Item Types
- BONUS - Troubleshooting Slow Code
- Creating A New Email With Create Item Method
- Early vs. Late Binding
- Set Up Your Own Constants To Soften Late Binding Blow
- Conditional Constants To Streamline Declarations
- Outlook Namespaces And How To Access Them
Video: 46 minutes, 11 lectures
- Creating An Email Using GeDefaultFolder [Late Binding]
- Adding Recipients
- Adding CC, BCC and Using With-End With
- Set Importance, Read Receipt and Delivery Receipt Statuses
- Tell Outlook To Send Email Later (Deferred Delivery)
- Sending Out First Email Automatically
Video: 48 minutes, 13 lectures
- 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
Video: 2 hours & 56 minutes, 22 lectures
- 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
Video: 3 hours & 8 minutes, 19 lectures
- 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
Video: 1 hour & 13 minutes, 9 lectures
- 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 Task Item
- Calculate Overdue Tasks; Auto-Email or Mark Complete Based on Task Ownership
Video: 47 minutes, 6 lectures
- Create A New Contact
- Other Contact Fields of Interest
- Quickly Set Contact Object Using Full Name
- Check If Worksheet Contact Exists Before Adding
- Iterate Through Contacts and Put Them In Excel Sheet
- Fill Userform List Box With Outlook Contacts
- Edit Contact Selection From Userform List Box
- Send Email To Selected Userform List Box Contact
Video: 1 hour & 20 minutes, 8 lectures
- Accessing Important Hidden Collections & Putting Into Combo Boxes
- Automatically Find Buried Folder Recursively - Custom Function
Video: 13 minutes, 2 lectures
