Macro to open outlook Email with conditions.

Hi team,

Let me explain the manual activity that I am doing for which I am trying to create a macro.

I am asking for a detail to 30 different groups of people. So I am sending 30 emails with same body of email but the people in “To” and “CC” differ in all the mails.

I have an excel file that have the project name, email address to be in the “To” field and Email address in the “CC” field. Also have the body of the mail.

I am trying to create a macro by which the step is automated. So when I run the macro against each project, the outlook mail should be opened with the To,CC and body of the mail filled.

Auto Email.xlsx
Please help me. Attached is the excel file.