I need to send a congratulation mail to multiple recipients who has got the certificates.
Now the template is embedded in an outlook message itself. It looks like this:
Now as you can see, the CERT_Name will be replaced by candidate name, Project_Name will be replaced by actual project name.
Now basically this will be the Body of the outlook message.
In TO field, we have to give recipient’s email, in CC we have to give email of his manager and delivery manager.
Now there is a excel file that has all these fields : Recipient Name,Email, Project Name, Manager email, Product manager email, recipient email etc.
I have to send it to some 200 people, this will happen every month once.
Any idea how to proceed?