Automate Email From Excel || VBA Macro to Send Outlook Mail with Snapshot || Send Mail with Picture
Automate Email From Excel || VBA Macro to Send Outlook Mail with Snapshot || Send Mail with Picture
Emails are a crucial part of communication in today’s digital world. However, it can take a lot of time to send emails individually, especially if you have many recipients. Luckily, you can use VBA in MS Excel to automate this email sending process. In this Video, we’ll show you how to use VBA to Send Email from Excel with Attachment and Image in Mail Body
and you will learn how to send an Outlook Email with mail body snapshot like Excel tables, Charts or images by using VBA. We will use “Mail Envelope” method to sending the email. This method is quite easy and small. You will also learn how to add attachment, subject, To, cc using VBA codes. Hope, you found the video useful.
We have to create our data on a worksheet in email format and It will send the entire worksheet or selected range on outlook mail body.
🎬Watch our most recent videos:
1. Sending Mass Email Quickly and Easily Using VBA- • Sending Mass Mail Quickly and Easily ...
2. VBA Code to Send Bulk Email From Outlook - • VBA Code to send Bulk Mail From Excel...
3.VBA Macro to Send Outlook Email With Snapshot- • Automate Email From Excel || VBA Macr...
4.Learn the Usage of Vlookup, Choose and Right Function- • Learn the usage of vlookup, Right fun...
5.Sumifs With Multiple Criteria - • Sumifs with multiple criteria #excel...
Here is the code :
Sub Send_Email_With_snapshot()
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets("Sheet1")
Dim lr As Integer
lr = sh.Range("A" & Application.Rows.Count).End(xlUp).Row
sh.Range("A1:H" & lr).Select
With Selection.Parent.MailEnvelope.Item
.to = sh.Range("L6").Value
.cc = sh.Range("L7").Value
.Subject = sh.Range("L8").Value
.attachments.Add "C:\Users\User\Desktop\Projects\Mar-2018.xlsx"
.send
End With
MsgBox "Done"
End Sub
1.How to send email with picture
2.How to send picture email from computer
3.How to send mail with attached file
4.How to send email with photo
5.How to send mail with attachment
6.vba code to send email with attachment from outlook
7.vba code to send email from outlook
8.vba code to send email with attachment
9.vba code to send email with multiple attachment
10.vba code to send email with attachment from excel
11.vba code to send email with active workbook as attachment
12.vba outlook email
13.vba outlook automation
14.vba outlook auto send mail
15. #advanceexcel
16. #advanceexcel
17. #vbamacro
18. #bidashboard
19. #exceldashboard
20. #reportautomation
21. #sendmailusingvba
22. #sendoutlookemailwithmailbodysnapshot
23. #mailenvelopeinvba
24. #mailenvelopemethodofsendingmail
25. #howtosendexclerangeonmailbodyinvba
26. #vbatutorial
27. #outlookautomation
28. #connectexclewithoutlookusingvba
#sendemailwithexcel #htmloutlook #htmlexcel #htmlvba #sendemailwithoutlook #sendemailwithexcelvba #excelvbaoutlookhtml #changefontinemailwithvba #excelvbaoutlook #outlookobjectlibrary #excelvbamacrooutlook #sendemailwithexcelmacro #htmlinexcelvbamacro #htmlmacro #formatdateinoutlookexcelvbamacro #excelvbasendemail
#excel #exceltips #excelinterview #exceltutorial #vba #outlook #outlookvba #vbaoutlook #automationfever #excel #vba #excelmacros #excelvba #sendmail #sendbulkemails vbacodetosendbulkemail #howtosendbulkemail #emailautomation #Howtosendbulkemailusingvba #advanceexcel #vbamacro #exceldashboard #excelautomation #reportautomation #vbatutorialforbeginners #userforminvba #createobjectinvba #createoutlook.applicationinvba #SendMail #SendOutlookMail #HowToSendMail #HowToSendOutlookMail #ExcelVba #MsExcelMeVba #sendmailusingvba #sendoutlookemailwithmailbodysnapshot #mailenvelopeinvba #mailenvelopemethodofsendingmail #howtosendexclerangeonmailbodyinvba #vbatutorial #outlookautomation #connectexclewithoutlookusingvba
#MsExcelMeMacro #AutomationFever #ExcelAutomation #VbaTutorial #ExcelVbaTutorial #ExcelAutomationVideos #excel #excelvba #excelmacros #vba #macro #vbamacros