VBA Email Excel Multiple Attachments and People in Outlook




About this tutorial:

Video duration: 3:28
VBA Email Excel. This works with Excel and Outlook 2007, 2010, and 2013. This video shows you how to send emails to multiple recipients. This video also shows you how to send emails with multiple attachments.

Source code below:
Sub EmailMacro()

Dim outapp As Object
Dim outmail As Object

Set outapp = CreateObject(“Outlook.application”)
Set outmail = outapp.createitem(0)

On Error Resume Next

With outmail
.to = “firstemail@outlook.com;secondemail@outlook.com”
.cc = “”
.bcc = “”
.Subject = “Test”
.Body = “Here is the message that…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *