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.
You can import your cert template to word and with use of this option generate certificate per each data from excel and even send it to recipients based on outlook engine. It will be much faster in your case (as you have all data in excel) than build whole Studio project.
Sure I understand
Then you could do the process where Word application is opened with your template. Then send hotkey to find the key word and replace it with word which comes from excel table kept in DataTable variable. Then it would save the file and with use of Outlook activities it could send it to recipient. Then put all of this into the loop so it could iterate per each excel row