Excel里的一列数据复制到邮件正文

[yt.yutao]

大家好，
请教一下怎么才能将excel里的一列数据复制到邮件正文发送出去，谢谢！

BRs
Yu Tao

[lrtetala (Lakshman Reddy)]

Hi @yt.yutao

Save the column into a separate datatable and Use Create HTML Content activity to send the column to mail

[yt.yutao]

Hi @lrtetala
Could you tell me more details? I am not very proficient in UiPath, thank you！

[mkankatala (Mahesh Kankatala)]

Hi @yt.yutao

→ Use the read range workbook activity to read the excel and store in a datatable, let’s call datatable variable as dt_Input.
→ After read range use the filter datatable activity to copy the Rework order column and store it in a other datatable, let’s call datatable as dt_Output.

→ After that use the Create HTML Content activity to put the datatable in that activity and use the output variable in body field in Send outlook or Send Email activity and check the IsBodyHtml option, you can findout this option in properties.

Check the below image for better understanding,

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@yt.yutao

You can try follow

1.Read Range your excel file and save it as DT.
2.Create new variable as New_DT datatype System.Data.DataTable
New_DT=DT.DefaultView.ToTable(False, "Your Column Name")
3.Create HTML Content activity
Click on Add data value

4.Send Outlook Mail Message activity

Cheers!!

[yt.yutao]

Hi @mkankatala ,

Thank you for your help.

BRs
Banksy

[yt.yutao]

Hi @lrtetala

Thank you for your help.

BRs
Banksy

[mkankatala (Mahesh Kankatala)]

You’re welcome @yt.yutao

Happy Automation
Regards