Create table with formatting

[inyourgravity]

Hi, I have used Build Datatable activity to create a datatable and would like to insert that datatable into my email body.
However, when use Output Datatable as string, the output would become:

Header1, Header2
ColValue1,ColValue2

Is it possible to create a datatable with formatting and borders etc within UiPath?

[Susana (Susana González Cacheiro)]

Hello @inyourgravity,

A simple solution could be create a template html of your body text, in the following link there is an example that you can use.

Copying dynamic excel data into email body

Hello @thetruestorey, Send outlook Mail Message activity allows to specifies whether the body of the message is written in HTML format throught the option isBodyHtml. A simple solution could be create a template html of your body text, for example “exampleBody.txt”. Once you have readen the different datatables from the excel exampleSusana.xlsx (in this example dt1 and dt2) you have to replace each token [DATA_SECTION_X] with the text “There is no data from this section” or with the html co…

Best Regards,
Susana

[ClaytonM]

Hello.

For an email body, you need to convert the table to html.

You might check this activity out created by the great vvaidya
https://forum.uipath.com/t/datatable-to-html/30801

Or you can create your own workflow component that reads in arguments and you can make it much more powerful that creates an entire email body into html with desired border and color properties.

[inyourgravity]

May I ask how do I write it into my body?
The output is string, but the outcome is not formatted.I got something like this instead.

[ClaytonM]

Hi @inyourgravity
In your Send Email activity, place that string in the Body property, and check the “IsHTML” property to checked.

Hope that answers it.

thanks.