Excel macro/VBA code available in this post: https://excelmacroclass.blogspot.com/2023/05/send-multiple-emails-from-excel-vba.html

In a previous video, we saw how to send an email from Excel (via Outlook) using VBA macros. We could add as many recipients as needed separated by a semi-colon when sending just one email. However, if we want to send separate emails to each recipient, we need to loop through the list of recipient emails and send an email to each of them individually. In this video, we see how to send multiple emails to recipients listed in a worksheet in Excel. We can choose to send the same or a different subject, body, or attachments to each recipient.

You can find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners) in the blog under the link: https://excelmacroclass.blogspot.com

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)

Please take the opportunity to connect and share this video with your friends and family if you find it useful.