Table formatting

[Ansari_Mohammed]

I have followed the resolution on:

How do i copy and paste table from excel to outlook email body?

Hi @SIM_JUN_HUI_BERTRAM_CSOD you could use any of these two packages, It will read data from excel and convert into html table (with cell color and font color) It has the activity called convert to html table (datatable to html table) Pass html table string we are getting from the activities output to send outlook mail message activity and tick isBodyHtml [image]

Used package: DataTable Manipulation - RPA Component | UiPath Marketplace
Passed the output through a variable. But the output looks like:

table style=‘border-collapse: collapse;border-style:Solid;border-color:#000000;border-width:1;’><td style='border-collapse: collapse;border-style:Solid;border-color:#000000;border-width:1;white-space:nowrap;padding-left: 6px;padding-right: 6px;padding-top: 3px;padding-bottom: 3px;background-color:#FFFFFF; font-family:Calibri;color: #000000;font-size:1em;font-weight:Normal;'E

and so on.

How can I fix this?

[Rahul_Unnikrishnan]

Hello @Ansari_Mohammed

Suggesting to use the Create HTML content activity to create the required html syntax and then to use the send email activity by enabling the IsHtml property.

https://docs.uipath.com/activities/docs/create-html-content