Macro to open Outlook and send one email to multiple addresses from excel columns

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.

Wow! Thanks a bunch daffodil11. Can you tell me what I might change in the code to open only (1) one email message for all email addresses? Also, it would be good if the emails going to the 'cc:' are actually going to the 'to:'. all email addresses with a 'yes' in their row should go in the 'to:' field in Outlook.

Thanks again!

So Cool! That works exactly like I was hoping it would. I hope others can find this code helpful for themselves as well.

Thank you daffodil11! ... and Thank you Excel Help Forum!!