How to put a table in email body

Hi All

I am exporting data from database in an excel format but i need to send some portion of data in a tabular form in an email body.

How can we form a table to send the same in an email body.

@kkpatel - output datatable to a string variable. Use replace string activity to:

 replace "," with "\t" and
 "\r\n" with "<br>"

Enable HTML in email setting.

Your email has html format for body or just text?

I don’t know actually how to have html body in email. As of now I am just passing strings in email body.

Hi
Hope this would help you

Cheers @kkpatel

cause tables would be harder to create using text, there is a property in the MailMessage to set body as html, then you create body like this: <html><body><table><tr><td>...</td></tr></table></body></html>

@kkpatel: isbodyhtml checkbox
image