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-send-email-vba-outlook/ 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