Send Basic Outlook Emails using Excel VBA (Tutorial 1: Send Outlook Emails)

Learn how to automate sending of Outlook emails using Excel VBA.

#vba #learnvba #excelvba #excel #exceltutorial #exceltips

This tutorial will cover various aspects such as how to connect to Outlook through Excel VBA to multiple scenarios for attaching files to the email. The last section of code shows how to loop over data and send multiple emails with one attachment each.

#vba #learnvba #excelvba #excel #exceltutorial #exceltips

You can find all the code at:

0:00 Intro
1:31 Blank Email Template
5:52 Email in Plain Text Format
10:39 Email in HTML Format
12:29 Early Binding/ Late Binding
15:46 Add Current Workbook as Attachment
17:55 Add Copy of Current Workbook as Attachment
21:44 Attach File From Folder
27:36 Attach Worksheet from Current Workbook
33:29 Read Email Properties from Worksheet
39:44 Create Separate Sub to Send Email
44:01 Send Multiple Emails with One Attachment Each
51:45 A Word of Caution when starting out

[blueskyu]

Very clear steps by steps approach, a very useful video. Thank you!

[janezklun]

Very useful video, thank you for sharing

[edge]

Thank you for this my friend... this is very useful!