Data Table Format in HTML EMail

[vrdabberu (Varunraj Dabberu)]

Hi @DawnW

Try writing DTEmail1 to an excel file and read that excel file. Please uncheck the Add Headers option in the properties Panel of Read Range Workbook activity and say the output to be dt.

Pass dt datatable in Create HTML Content. This should help you get the table in email with Headers also.

Please refer the below thread for reference

How to send dynamic and multiple table in email body

Hi @satish.rathi59 You can use Create HTML content activity to create the body and insert table and save the output in a Variable. Pass this output in Body field in Send outlook mail message or Send SMTP activity and check the IsBodyHTML option in properties. → Use the Read Range workbook activity to read the excel and store in a datatable variable. → Click on the Open editor option in Create HTML content activity a window popsup. → In that window, click Add data values, and click on Add …

Let me know if you have any issues.

Regards