I am sending out emails using the MailMessage() function, and I have the body saved as HTML in a .txt file. I would like my automation to loop through the HTML body and wherever it sees a variable indicator, it should populate that space with variables initialized in UiPath from an excel sheet. How should I go about doing this?
What I have tried thus far:
Neither of these have worked, and they both just show up in the email as that instead of the correct corresponding variable value.
@ppr Hi Peter, I was wondering, how would I implement this if I already have an excel sheet that a for loop loops through with the predetermined values? So for each iteration of the for loop, the value of, let’s say, strUser, is different each time.