Hi Team,
Please find the attached documents and a mail format.in the attachement i have two excel documents consists
1) Proposed matches : a list of match groups which need to be either approved or to be dissolved before a cut of time. for that we need to send the mails based on the "Dept" column.
2) Department Ownership : this file consists for owners of the "Dept"
3) the Mail is an example of how we are sending the mails to the specific dept owners
From the above details, is there any possibility that we can automate the process of sending of the mails to the respective users. because i am giving only few Depts and Proposed matches as i am supposed to send almost 100+ mails to the respective users which will take almost 2 to 3 hours to complete.
Please help me out this.
Regards
Surya.