Bulk Outlook Emails with CC and Attachments and Priority using Excel VBA
1,761
Published 2024-03-03
This video shows you the power of Excel VBA to dynamically via a loop compose and send an Outlook Email for each row of an Excel Dataset containing the required information.
It also shows you how to add the primary and multiple CC circular email addressees with multiple attachments and set the priority for each one.
This method also uses late binding where the Outlook Application object is created during runtime so you don't need to go the the VBA editor menu to select references for the Outlook Object library.
Doing it this way makes it easy to share your Excel workbook with users without issues.
If you enjoyed watching this video consider subscribing and share this amazing Excel Power Tip with others.
Enjoy!
LIKE - SUBSCRIBE - COMMENT - SHARE - ENJOY!
All Comments (4)
-
Yes you should be able to attach any document file as you specify the full path in the Excel sheet for the VBA code to pick. Thanks for watching.
-
Hii sir.. I want to send excel table to outlook to more recipients... Can you help me how to create that
-
Can I post an image also in Mail Body..... Asking coz when we past in Excel it does not show the same?
