Training videos for learning VBA - WORKING WITH OUTLOOK

VBA - working with Outlook - 11 videos

Excel VBA Part 29.1 - Creating Outlook Emails

Posted by Andrew Gould on 26 March 2014

Writing VBA code in Excel doesn't only allow you to control Excel, you also have access to all of the other Office applications. This video looks at how to create emails in Microsoft Outlook by writing code in Excel. You'll learn how to reference the Outlook Object Library, several methods for creating a new instance of the Outlook application and how to create new emails. You'll see how to set basic properties of an email, such as the address and subject and also how to add attachments and make sure that the email includes a signature. The video spends a lot of time talking about the different email formats and how to set the body text of the email according to which format you've chosen; this includes how to write plain text emails, and how to construct basic HTML emails including how to format them. Towards the end the video also shows how to write emails using the Word Editor, allowing you to copy and paste information directly from Excel.

Excel VBA Part 29.2 - Outlook Email Events

Posted by Andrew Gould on 29 August 2017

This video explains how to use the WithEvents keyword to access the Send and Close events of an Outlook MailItem. You'll learn how to use a basic class module to enable access to the events of an object, as well as how to create basic event handlers.

Excel VBA Part 29.3 - Outlook Emails using the Word Editor

Posted by Andrew Gould on 29 April 2019

This video explains how to use the Word Editor of an email created in Outlook to access a range of useful editing features. You'll learn how to create an enmail, how to reference the Word editor and how to work with the Word Range object. You'll use these skills to compose an email consisting of literal text combined with a copied Excel table and chart.

Excel VBA Part 29.4 - Inserting Pictures in Outlook Emails

Posted by Andrew Gould on 29 April 2019

This video explains how to write VBA code in Excel to insert a picture from a file into an Outlook email. You'll learn how to get a reference to the Word Editor of an Outlook email and use this to create a new Inline Shape object. You also see a few basic techniques for resizing and formatting the picture that you've inserted.

Excel VBA Part 29.5 - Copying Emails from the Outlook Inbox

Posted by Andrew Gould on 29 April 2019

In this video you'll learn how to loop over the items in the Outlook Inbox folder and write the details of each email into an Excel worksheet. You'll learn how to reference an Outlook Namespace and a default folder, the basics of the Items collection and how to use the WordEditor of an email to paste an embedded Word document into Excel.

Excel VBA Part 29.6 - Referencing a Named Folder in Outlook

Posted by Andrew Gould on 29 April 2019

This video explains how to reference and loop over the items in a named folder in Outlook. You'll learn about Outlook's folder structure, how to reference the root folder of an Outlook namespace and how to loop over a collection of folder items, writing the details into a worksheet.

Excel VBA Part 29.7 - Looping Through All Outlook Folders

Posted by Andrew Gould on 29 April 2019

This video explains how to loop over the folder and subfolder structure in Microsoft Outlook and list the contents of each folder in an Excel worksheet. You'll learn how to set up a recursive procedure to walk through the hierarchy of folders in an Outlook account and how to layout the results using different indent levels in an Excel worksheet.

Excel VBA Part 29.8 - Saving Attachments from an Outlook Folder

Posted by Andrew Gould on 29 April 2019

This video explains how to save the attachments from a collection of emails in an Outlook folder. You'll learn how to identify which emails have attachments, how to loop over the attachments collection and how to use the SaveAsFile method. You'll also see how to use a FileSystemObject to create a new folder for each email's attachments collection.

Excel VBA Part 29.9 - Finding Outlook Emails using Filters

Posted by Andrew Gould on 29 April 2019

In this video you'll learn how to use the Find method and filters in Outlook to search for an email by sender name and subject. You'll learn how to retrieve a list of items from the Outlook inbox, how to apply the Find method to the Items collection and how to construct a filter string to get a reference to a single item in the collection. You'll also learn of a potential issue with the subject of replies and forwarded messages as well as how to deal with the problem. Finally, you'll learn how to copy the body of an email into an embedded Word document in an Excel worksheet.

Excel VBA Part 29.10 - Getting Emails from another Outlook Account

Posted by Andrew Gould on 07 May 2019

Learn how to reference folders in multiple accounts in the same Outlook profile. This video teaches you how to find the names of each Outlook account folder and how to loop through the Inbox items for each account. You'll also learn what an Outlook Store object is and how you can use it as an alternative way to access another account's inbox.

Excel VBA Part 29.11 - Sending Emails from another Outlook Account

Posted by Andrew Gould on 07 May 2019

This video briefly explains how to choose which account is used to send emails from Outlook using Excel VBA. You'll learn how to list the account names of an Outlook profile and how to use the SendUsingAccount property of an email.

This page has 0 threads Add post