Hello.
I would like help to create a macro to send (1) one email to multiple email addresses found in a worksheet. This macro should be able to open Outlook if it's not already opened, populate the 'To:' field with all the emails addresses that match the criteria noted in the attachment. I will then manually enter the subject and body of the email to complete sending it.
I have attached a workbook to show that only rows with the word 'yes' in column E should be used to send emails to the addresses in column C and D.
It would be handy to have a button in the worksheet to invoke this macro but if too much trouble then not a big deal.
Thank you so much for all of your help and suggestions.
Bookmarks