Quote Originally Posted by john55 View Post
see if it works
Thanks a lot John for updating the codes. I am excited and happy to see this working . Please help to make few more changes..

The “To “and “CC” is working perfectly fine. I also have the “From” field enabled and have access to send from multiple mail Ids. The cell H2 in the latest excel has the mail ID that has to be updated in the “From” Field. Please help by updating the codes so the “From” is updated as per H2.

Attaching the doc in the mail is not working as expected. The current macro picks the file based on the filename that is updated in the codes. That has to be updated in such a way that the macro picks up the right file from the destination folder.
The folder in my desktop will have many excel files named welcome AAA, Training AAA, welcome ABB, Training ABB etc.. So when the mail is automatically drafted for the project “AAA”, it has to attach all the files that end with “AAA.xlsx” from the destination folder.

Please also help in bringing the image in the excel to the body of the email. The image should be under the sentence “We welcome you all to the project...”
Requesting for your help.