Macro to send mails from outlook as per the email ids in excel

Originally Posted by john55

it works with different folders according to yr projects name, I do not know how to attach the file(s) from a single folder to different recipients! I am sorry!

Thanks a lot for replying John... The macro is going to reduce several hours of my work .. The sample data has only 10 projects, but in reality its 30 to 40 projects.. You are a game changer!!

Let’s hold on to the attachment part bcoz I am using a diff macro that saves all the files to one folder. So saving to individual folders is not possible now. Let me update the other macro to create individual folders post which I will use your latest codes.

Attached is the latest version of sample data.. I made minor changes to add more columns in TO and CC and to save the mails in the draft folder.

I have few clarifications more before closing the thread..
Can you help me bring the image in the excel to the body of the email.. Also please let me know how to change the font and size of the sentences in the body of mail and change the page color..
Please help..