I am using the outlook send mail activity to send confirmation emails to potential job candidates. I have created an email template using notepad (and have checked the isHTML option in UI Path). I have an excel file that I want it to read from and include certain details in the body of the email such as date and time. I am looking for suggestions of the best way incorporate these variables into my HTML text file and the workflow.
See attached excel file example.
List of Emails to Send.xlsx (8.7 KB)