From Excel Datas to E-mail Html Body

[yigit.aybey (Kuki_Shinobu)]

Hello all,
i want to send a table as you can see the picture below. It should be seeing like that.

and my excel is like that.

I’m using send exchange mail activity. Can you help me how can i do like that and if it is possible can you explain step by step. And also i have more than 1 sheets.

Thank you.

[supermanPunch (Arpan)]

Hi @yigit.aybey ,

Check the Below Post which helps you in Conversion from Datatable to Html Table format :

DataTable to HTML using Assign Activity

Hi @JavRR , Glad to know that it is useful to you You could try below expression to get what you wanted to. HTMLBodyStr="<table border=2><b><tr><td>"+String.Join("</td><td>",TestDt.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).ToArray)+"</td></tr></b>"+ "<tr>"+String.Join("</tr><tr>",(From x In TestDt.AsEnumerable Let cells="<td>"+String.Join("</td><td>",x.ItemArray)+"</td>" Select cells).ToArray)+"</tr>" Thanks,

The Output would be a String which you could then use to append to the body of the mail.

The Configuration of the Send Exchange Email Body Activity Should have Property IsBodyHtml Checked (Enabled).

[yigit.aybey (Kuki_Shinobu)]

I got this error.

my code

my_table => Read Range output variable
Read Range => Reading excel files

[supermanPunch (Arpan)]

@yigit.aybey , In the R.H.S of the Assign Activity remove HtmlBodyStr=

[yigit.aybey (Kuki_Shinobu)]

it worked very well.
thanks for your help.