How to insert several excel columns in the body of the mail

[Ana_Patricia_Garcia]

Hello friends!
I have an excel document, the document has several columns with data.
In the body of the mail I want to add several columns and show that information. How it is performed? through a chain? or HTML?

Could you give me an example please

[ushu (Usha kiranmai)]

Hello @Ana_Patricia_Garcia - Hope the below thread would helps you!!

How to write excel data in outlook mail?

I created a workflow wherein bot reads the excel data and then created a loop for each row. How could I: Read the excel column and write sender’s name dynamically in “to” of “send outlook mail message” activity? copy excel sheet header and a row in the outlook mail “body” and send to multiple users (each row to each user+ header which is common for all) Please suggest some code which could convert the datatable to string such as its tabular format is not lost. Also, Screen scraping or copy …

[ushu (Usha kiranmai)]

@Ana_Patricia_Garcia Please refer this as well

Convert data table to HTML to be included in email body

Use Create HTML Content Activity. First Design the mail format in MS Word and then copy paste it into the activity. If you want the table values to be dynamic then there is option of mapping values to the variables in the activity. Refer the screenshots below. [image] [image] It is a new activity. It is added in the latest package of UiPath.Mail.Activities 1.10.4 You can directly copy tables from excel and paste it into the editor of this activity and then the data values can be mapped eas…

[ppr (Peter Preuss)]

@Ana_Patricia_Garcia

In the body of the mail I want to add several columns and show that information. How it is performed?

it depends from if you want to send a text email or a html email

Once you have decided then create the email body.

For converting a datatable into text we do it e.g with output datatable or customize it.

for converting the datatable to a HTML table we do have some components from the marketplace or we are using the Create HTML Content activity supporting datatable as variables (we have smal bug but also a workaround to it)

[Naveen_Veeravalli (Veeravalli Naveen)]

@Ana_Patricia_Garcia
Try this work flow
DataTableToHtmlText.xaml (14.5 KB)