how to send specific column data of excel to mail in uipath
e.g. if you want to send “column1”
put this in your email body:
String.Join("<br>", dt.AsEnumerable.Select(function(row) row("column1").toString).toList)
remember to tick “isBodyHTML” in send outlook message activity
if your excel looks like this
then the above code will put this in your mail body"
a
b
c
if i want to send two column of excel then
Hello @Yogita_Gaikwad ,
The below workflow will help you to understand how to Pass the multiple columns values in Email Body.
ExcelToMail.xaml (21.4 KB)
Hi @Yogita_Gaikwad,
You can use the create html content activity. You can add dynamic variables and tables.
Read the excel first, then add it as a table.
Regards,
MY