How to write excel data in outlook mail?

Help
,
6

Hi all,

For converting Excel datatable into a table in body of email, you can try this out:

  1. Read the datatable ie dt.
  2. Count the rows and columns of the datatable → dt.rows.count and dt.columns.count.
  3. Create a html document with a table open tag using uipath (use activity write/append line to create a .html file and append the lines).
  4. Create a dynamic table using tag with the datatable content. → use for each activity and append line to the .html file.
  5. close the html tags.
  6. send the html file as body in the Outlook mail activity. (click on ishtml check box)

Thank you
Nitin Safaya

1 Like