Mail

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
image
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