VBA Email Excel Multiple Attachments and People in Outlook
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.
https://vbatutorialcode.com/how-to-se...
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 = "[email protected];[email protected]"
.cc = ""
.bcc = ""
.Subject = "Test"
.Body = "Here is the message that appears in the body of the email."
.Attachments.Add ("C:\Users\Nonaluuluu\Desktop\Attachement1.png")
.Send
End With
On Error GoTo 0
Set outmail = Nothing
Set outapp = Nothing
End Sub