Hi Team,
I am trying to find codes to automate one of the manual activities that I do daily.
I am sending a same mail from outlook to different people. The body of the mail remains the same, people in “To”, “CC”, attachment, and part of subject changes in every mail.
I have an excel with list of projects, Email IDs of the project who should be in “To” and “CC”. So if there are 10 projects in the excel, I will have to draft 10 emails with same content in the body of the email.
I am looking for codes by which if there are 10 projects in the excel, 10 mails are created with people in “To” and “CC” updated as per the excel and mail is saved in drafts folder. Attachments for each mail is saved in a folder in my desktop.
Subject of the mail is “welcome to - “project name”. “Welcome to” is common in all mails but project name should be as per the excel.
Please help me with suggestions. Sample data attached. Please help.
Bookmarks