Email was not able to address to correct recipient

[Angel1524]

I want to send email to different person:
First email to : Dear Simon, …” ; second person to: “Dear Peter…”.

A test run shows that the email was sent out to the correct email address, however, the email keeps addressing the person as “Dear Simon” instead of “Dear Simon” and “Dear Peter”. What is wrong with my command in the html message and assign commands? Please help as this is my first attempt in using Uipath. Thanks!

[shaikmdrafi (shaik mahammad raphi)]

Hi @Angel1524

Can you try by putting PrefeeredNameFromExcel variable to the body.

Thanks

[Angel1524]

Tried to put PreferredNameFromExcel in html body but it appears as “Dear PreferredNameFromExcel”.

[shaikmdrafi (shaik mahammad raphi)]

please refer this post, this may help

Create Text from Excel info

Hi @jack-keenan-clancy welcome to forum For this First create a text file with following text Hello Name Your meeting time is at Time Thank you Read the excel field and store in dt1 Use for each row to loop through each rows of dt1 Inside it use the following Read the text file and store in stringvariable body use Assign activitiy to assign body varible with values of each rows from excel body = body.Replace(“Name”, row(0).ToString). Replace (“Time”, row(1).ToString) Then aft…

Thanks.

[Angel1524]

Error message when I keyed the command in the assign value

[Angel1524]

Error message. Anyone can help ?