How to send text in table format in mail body

Help Studio
, ,
1

Hi I have 3 strings need to add header
checkpoint status comments
& add that 3 string values in these 3 columns(checkpoint status comments)
as a table format in mail body.
Please help

2

Hi @vnsatyasunil ,
I understand you need add a table have 3 columns to body email
That’s right?
If it’s right. You can create body email as HTML format.
https://docs.uipath.com/activities/other/latest/productivity/create-html-content
Regards,
LNV

3

Use create html content

1 Like
4

ok thanks. Can we use create html content output variable in mail body and send mail

5

Activity:Create html Content
You will have an option of insert table! in property panel set the output variable.
Once its done write the output variable in body of the mail

1 Like
6

You will have an option of insert table! in property panel set the output variable.
Once its done write the output variable in body of the mail

1 Like
7

Yes, You can create variable output

8

ok will try it Thanks

1 Like
9

Hey @vnsatyasunil , You can build datatable with the 3 columns using Build datatable activity
Populate the datatable with required fields

After that there are 2 Solutions

Method 1: Using Create HTML Content activity
If you want to go through this activity directly then you wont be getting the headers
so if you want column headers , write the datatable back to excel and then again read the workbook with ADD HEADERS Option Unticked

After that send that Datatable to Create HTML Content and it will work!

Method 2: You can use Linq query which will convert your datatable into html content directly
Please find the Linq code below

"<table border=2><tr><td>"+String.Join("</td><td>",YourDT.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).ToArray)+"</td></tr>"+
"<tr>"+String.Join("</tr><tr>",(From x In YourDT.AsEnumerable
Let cells="<td>"+String.Join("</td><td>",x.ItemArray)+"</td>"
Select cells).ToArray)+"</tr>"

Replace YourDT with your Datatable in the above code

Hope it helps you !

5 Likes
10

This solution works, thanks !

1 Like
11

This works! It is the easiest way to include/implement structured data’s (like datatables) in a mail body.

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.