Excel VBA & Microsoft Outlook Mastery and Automation
Create And Manipulate Outlook Emails, Attachments, Calendars, Tasks, and Contacts Automatically With Excel VBA
4.61 (232 reviews)
1,832
students
11 hours
content
Sep 2021
last update
$174.99
regular price
What you will learn
Automate Microsoft Outlook with simple Excel macros
Create and manipulate emails using MailItem methods
Understand Outlook Namespaces (folder system)
Display, Save drafts or Send Emails using automation!
Set up CC, BCC and Distribution Groups with ease
Loop through Excel and automatically generate custom-tailored emails with each row's data
Get a quick Burner email for testing (Free)
Tell Outlook to send email Later (Deferred delivery)
Prevent Outlook warnings that Halt emails being sent
Seamlessly control Multiple Outlook accounts
Spice up messages using HTML dynamically
Learn most effective free HTML editors
Utilize large HTML files with custom data (like a mail merge)
Using signature the right way - including non-default signatures
Breeze through emails in Outlook Folders
Find specific items with Find method
Filtering Multiple results using Restrict method
Finding an item by its Unique Entry IDentifier
Take control of Advanced Filtering using DASL queries
Personalize emails and attachments with Excel data
Save time with an Outlook Template file
Click any cell to auto send that person an email!
Validate email addresses with Custom Function
Place an Excel Range/Table into email body (2 methods)
Attach pc files, single sheet, multiple sheets or even entire current workbook!
Save worksheet as PDF & Attach to email!
Generate Random filenames for attachments
Move or Copy items within Outlook (or on your pc)
Open & Gather Data from email attachments and Build Reports
Master Calendar items (Appointments & Meetings) and schedule like a boss!
Instantly understand (and have fun with) Date/Time Math
Discover Schedule Conflicts the easy way
Create, assign, modify and streamline Task Items
Search for Contacts using ‘FullName’ shortcut or with Loops
Scan Contacts lists & put specific ones into Excel
Build a Custom Userform that can Email or Edit the selected contact!
Related Topics
2595942
udemy ID
10/7/2019
course created date
11/28/2019
course indexed date
Bot
course submited by