Excel VBA & Microsoft Outlook
Mastery and Automation

Create And Manipulate Outlook Emails, Attachments, Calendars, Tasks, and Contacts Automatically With Excel VBA

$54

Great news! You already have access to this course! 👇

90

Lectures

11:10H

Duration

ALL

Skill Level

ENGLISH

Language

COURSE OVERVIEW

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.

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

WHAT YOU'LL LEARN

WHO THIS COURSE IS 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!

What Students Say About The Course

STUDENTS' TESTIMONIALS

30-DAY MONEY BACK GUARANTEE

We are confident that our course will provide you with immense value and help you achieve your goals. To demonstrate our commitment to your satisfaction, we offer a 30-day money back guarantee. If for any reason you are not completely satisfied with the course within 30 days of your purchase, simply contact our customer support team, and we will refund your full payment. No questions asked! 

Frequently Asked Questions

  • You should already have Microsoft Excel for PC. Obviously the newer the better, but VBA works the same in all versions. It’s just that newer versions have more options, thus more VBA Commands to control those options.
  • 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.
  • Very basic Excel skills needed for this course. If you know Basic to Intermediate Excel VBA, you can surely find more ways to utilize this information, but it is not required as I explain everything in detail.
  • This course doesn't cover CDO emails because it's specifically for Outlook and all its various amazing features. We'll cover CDO in another course for a more focused look.
  • The course will start right away upon signing up, you get instant access.

How would you like access to ALL our Excel courses?

  • Excel Ninja Pro is a subscription streaming service that offers a wide variety of Excel resources, including premium online courses, code vault, swipe files, downloadable workbooks, projects, events, and a results-driven community of Automators.

  • You can watch as much as you want, commercial free - all for one low monthly price. There's always something new coming soon and Ninja Pro members get to help decide what comes next!

Learn more HERE.

Visit the My Courses link at the top left of the site menu. You can also visit the Member's Area and click on Courses tab.

NOTE: You should have an email with a username and link to reset password initially. If not, please check spam folder (if none, contact us immediately or see "How do I change/update my password?" above).

  • Today’s World is full of busy people that want to better themselves, so self-paced programs are popular. Yes, you can learn at your own speed, so that you can focus on things that you find challenging and breeze past things that you already know. You will be the one to decide when to start accessing the course materials and when to finish.
  • Yes, definitely! If you have questions about the lesson, we will answer all your questions as soon as possible.
  • Does lifetime access sounds good to you? You'll have unlimited access to the course once you've enrolled. This means you can re-watch lessons whenever you need and complete the course at your own pace.

Every course in the member's area comes with a 'Certificate of Completion' that you can add to your LinkedIn bio, to your resume or even brag to your friends.

You also get achievement badges the more you participate, comment, and share with the group. You can check out our achievement’s dashboard!

© 2024 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.
X

Forgot Password?

Join Us

1
    1
    Your Cart
    Ultimate Excel VBA Arrays Course
    1 X $44.00 = $44.00