Excel VBA & Microsoft Outlook Mastery and Automation

Excel VBA & Microsoft Outlook Mastery and Automation, available at $174.99, has an average rating of 4.55, with 90 lectures, based on 230 reviews, and has 1830 subscribers.

You will learn about 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! This course is ideal for individuals who are This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for creating, managing and updating Emails, Calendar Items, Tasks, and Contacts in Outlook. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed, but some Excel VBA familiarity never hurts! or This course doesn't cover CDO emails because it's specifically for Outlook and all it's various amazing features. We'll cover CDO in another course for a more focused look. or If you're using Excel or Outlook for Mac, you will find that this course won't cover all the various Mac nuances, as this course was filmed using a PC. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp. It is particularly useful for This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for creating, managing and updating Emails, Calendar Items, Tasks, and Contacts in Outlook. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed, but some Excel VBA familiarity never hurts! or This course doesn't cover CDO emails because it's specifically for Outlook and all it's various amazing features. We'll cover CDO in another course for a more focused look. or If you're using Excel or Outlook for Mac, you will find that this course won't cover all the various Mac nuances, as this course was filmed using a PC. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.

Enroll now: Excel VBA & Microsoft Outlook Mastery and Automation

Summary

Title: Excel VBA & Microsoft Outlook Mastery and Automation

Price: $174.99

Average Rating: 4.55

Number of Lectures: 90

Number of Published Lectures: 90

Number of Curriculum Items: 90

Number of Published Curriculum Objects: 90

Original Price: $174.99

Quality Status: approved

Status: Live

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!

Who Should Attend

This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for creating, managing and updating Emails, Calendar Items, Tasks, and Contacts in Outlook. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed, but some Excel VBA familiarity never hurts!
This course doesn't cover CDO emails because it's specifically for Outlook and all it's various amazing features. We'll cover CDO in another course for a more focused look.
If you're using Excel or Outlook for Mac, you will find that this course won't cover all the various Mac nuances, as this course was filmed using a PC. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.

Target Audiences

This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for creating, managing and updating Emails, Calendar Items, Tasks, and Contacts in Outlook. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed, but some Excel VBA familiarity never hurts!
This course doesn't cover CDO emails because it's specifically for Outlook and all it's various amazing features. We'll cover CDO in another course for a more focused look.
If you're using Excel or Outlook for Mac, you will find that this course won't cover all the various Mac nuances, as this course was filmed using a PC. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.

The world has well over a billion Microsoft Office users, and many of them are starting to realize that you can automate your work life with VBA. They use Excel for data analysis, report generation or keeping up with complicated list and calculations, and use Outlook to keep their schedule straight – with tasks, Emails, Meetings and Contacts..

One of the least published and least utilized strategies is using the best of both worlds – the flexibility, calculations, speed & data storage of Excel and the Email, Tasks, Calendar and Contacts of Outlook. This course marries those two technologies in a simple, progressive manner that Beginners can understand and Experts will return to over and over for reference.

You’ll learn to:

Utilize and manipulate Outlook’s organizational structure and folder system to
Create dynamic emails and auto-send, defer delivery, display or save emails as a draft
Loop through Excel and automatically generate custom-tailored emailswith each row’s data
Get free burner emails for testing
Seamlessly control MultipleOutlook accounts
You’ll even learn to Spice up your messages using professional HTML emailcode, using Free HTML editors and where to find cool templates
We’ll guide you through multiple methods of Signature automation, including non-default signatures
You’ll also master looping through your emails with custom filters, including Advanced DASL queries (made simple!)
You’ll Personalize emails and attachments with Excel data or Auto-Open specific attachmentsand Grab Data into your workbook!
You’ll be able to convert Excel tables into HTML and embed them into your email body

In addition to Email mastery, we also show you how to:

Create, modifyand rearrangeCalendar items (like Appointments & Meetings) and schedule like a boss!
Instantly understand (and have fun with) Date/Time Math
Discover and prevent Schedule Conflictsthe easy way
Create, assign, modify and streamline TaskItems
Utilize outlook Contacts with your Excel program
We even take you through Building a Custom Userformwhere you’ll be able to Email or Edit any of YOUR contactsright from Excel!
You can easily implement these strategies in any of your Excel programs to further automate your workflow
Impress your boss! Go ahead, make your work take 5 minutes instead of 5 hours. (We won’t tell!)

Go ahead and Grab your copy of this Excel and Outlook VBA Mastery Course – TODAY!

From the Author, Dan Strong:

Some of the most common questions I get is “How can I automatically send emails based on Excel data?” or “How can I cycle through my emails and grab info from specific attachments?” So, I decided to create an intensive study course that shows you every aspect of Microsoft Outlook from the viewpoint of an Excel program – AKA showing you how to send out emails wayyyy beyond a simple mail merge or a ‘SendMail’ action. You’ll be able to take Outlook by the horns and implement a whole new set of tools to your toolbelt.

We’ll see you in the Forums!

Happy Coding

Dan Strong, ExcelVbaIsFun

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction and Course Download Files

Lecture 2: The Outlook Application Object

Lecture 3: CreateItem Method and Item Types

Lecture 4: BONUS – Troubleshooting Horribly Slow Code

Lecture 5: Creating A New Email With CreateItem Method

Lecture 6: Early vs Late Binding

Lecture 7: Early vs Late Binding – Really Good Article

Lecture 8: Set Up Your Own Constants To Soften Late Binding Blow

Lecture 9: Our First Batch of Constants (For Your Convenience)

Lecture 10: Conditional Constants To Streamline Declarations

Lecture 11: Outlook Namespaces and How To Access Them

Chapter 2: Sending An Email!

Lecture 1: Creating A New Email Using GetDefaultFolder() [Late Binding]

Lecture 2: olDefaultFolders enumeration List

Lecture 3: Adding Recipients (Method 1)

Lecture 4: Adding CC, BCC and Using With-End With (Method 1)

Lecture 5: Set Importance, Read Receipt and Delivery Receipt Statuses

Lecture 6: Add Subject & Body and Popup for Review!

Lecture 7: Save Email as Draft Instead of Sending Right Away…

Lecture 8: Tell Outlook To Send Email Later (Deferred Delivery)

Lecture 9: Create a Quick Burner Email For Testing

Lecture 10: Sending Our First Email Automatically

Lecture 11: Stop Outlook Warnings That Halt Emails Being Sent

Lecture 12: Send Using Alternate Sender Name

Lecture 13: Better Method To Send With Alternate Account (Non-Primary Account)

Chapter 3: Fun Email Tricks

Lecture 1: Sending HTML Email And Easy Customization

Lecture 2: Customize HTML With Outlook Trick

Lecture 3: Free HTML Editor To Make Cool Looking Email Elements

Lecture 4: Dealing With Large HTML Body

Lecture 5: Dealing With Large HTML (Method 2 TXT File)

Lecture 6: Adding A Simple Signature to Email

Lecture 7: Adding The Default Signature to Email

Lecture 8: Using A Different Signature

Lecture 9: Accessing Outlook Folders by Name

Lecture 10: Looping Through Items (Emails) In A Folder

Lecture 11: Finding Specific Item With Find Method

Lecture 12: Filtering Multiple Results Using Restrict Method

Lecture 13: Does Outlook Folder Exist and Adding New Folders

Lecture 14: Finding An Item By It's Unique Entry Identifier

Lecture 15: Setting Default Inbox Folder For Loops

Lecture 16: Search Emails Dynamically For Past Week or Last 30 Days

Lecture 17: Advanced Filtering Using DASL Queries – Pt 1

Lecture 18: Advanced Filtering Using DASL Queries – Pt 2 – Special Operators

Lecture 19: Testing It Out And Determining If Instant Search Is Enabled

Lecture 20: Easy Way To Instantly Discover DASL Syntax For Complicated Queries

Lecture 21: DASL Filter Demonstration and More Concatenation Examples

Lecture 22: DASL Reference Materials

Chapter 4: Attachments & Personalized Emails With Excel Data

Lecture 1: Open An Email Template File

Lecture 2: Intro To Customizing with Auto Find and Replace

Lecture 3: Sending A Custom Email to A Specific Row On Worksheet

Lecture 4: Creating A Clickable 'Send Email' Column

Lecture 5: Looping Through Excel Data With Customized Emails Pt 1 (Name Filter)

Lecture 6: Looping Through Excel Data With Customized Emails Pt 2 (Date Filter)

Lecture 7: Getting User Input and Assigning Buttons!

Lecture 8: Generating One Email To An Automated List (To, CC or BCC)

Lecture 9: Custom Function To Validate Email Addresses

Lecture 10: Converting A Range To HTML and Placing In Email

Lecture 11: Embedding A Range In Email Body Via Copy-Paste

Lecture 12: Adding A Simple Attachment From File Path

Lecture 13: Embedding An Image In Email Body

Lecture 14: Custom Function For Random File Name

Lecture 15: Attaching Worksheet To Email As PDF

Lecture 16: Attaching A Single Sheet To Email

Lecture 17: Attaching Entire Workbook To Email

Lecture 18: Save Email Attachments To Specific Folder If It Doesn't Already Exist

Lecture 19: Open Email Attachments And Gather Info Into Current Workbook!

Chapter 5: Calendar Manipulation & Appointments

Lecture 1: Calendar Items, Appointments and Meetings

Lecture 2: Adding A New Appointment

Lecture 3: Adding A New Meeting With Multiple Attendees (Recipients Method 2)

Lecture 4: Duration Versus End Time!

Lecture 5: DateAdd Function: Fun With Dates!

Lecture 6: Determining Schedule Conflicts With Simple Math

Lecture 7: Check If Proposed New Entry Has Schedule Conflicts with Restrict

Lecture 8: Custom Reminders, Sound Files, Minutes Before Start, etc

Lecture 9: Change Meetings With Bob To Red

Chapter 6: Outlook Tasks

Lecture 1: A Brief Overview of Outlook Tasks

Lecture 2: Create A New Task

Lecture 3: Assigning A Task To Someone

Lecture 4: Looping Through Existing Tasks

Lecture 5: Sending A Status Report For A TaskItem

Lecture 6: Calculate Overdue Tasks; Auto-Email or Mark Complete Based on Task Ownership

Chapter 7: Outlook Contacts

Lecture 1: Create A New Contact

Lecture 2: Other Contact Fields of Interest

Lecture 3: Quickly Set Contact Object Using FullName

Lecture 4: Check If Worksheet Contact Exists Before Adding

Lecture 5: Iterate Through Contacts and Put Them In Excel Sheet!

Lecture 6: Fill Userform ListBox With Outlook Contacts

Lecture 7: Edit Contact Selection From Userform ListBox

Lecture 8: Send Email To Selected Userform ListBox Contact!

Chapter 8: Other Outlook Tricks

Lecture 1: Accessing Important Hidden Collections & Putting Into ComboBoxes

Lecture 2: Automatically Find Buried Folder Recursively – Custom Function

Instructors

Daniel Strong
Excel Instructor/Programmer

Rating Distribution

1 stars: 3 votes
2 stars: 2 votes
3 stars: 12 votes
4 stars: 72 votes
5 stars: 141 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu