From Excel Datas to E-mail Html Body

[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).