Copy dynamic Table into outlook email

[hp321 (ap)]

Hi all!
I hope you can help me with the following:
I have a data table in excel that needs to be formatted as a table and sent via outlook email.
Tיis is the expected output:

Please note that the sheet name is dynamic, as well as the data range.
Please advise.
Thank you!

p.s. I can’t download this package:

DataTable Manipulation - RPA Component | UiPath Marketplace | Overview

[lrtetala (Lakshman Reddy)]

Hi @hp321

Use Create HTML Content activity

Cheers!!

[mkankatala (Mahesh Kankatala)]

Hi @hp321

You can use the Create HTML activity.
→ Click on Open editor
→ Click on Add data values → Click on Map Data Value → Add Value → Select the Table → Pass the Datatable Variable.

Check the below image for better understanding,

→ In the Create HTML content you can write the mail body and where you want to add the datatable click on Add data values and click on Table value.

→ Create a variable of the output of Create HTML Content activity.
→ Pass that variable in the Body field in Send outlook mail message activity. In the properties of that activity check the IsBodyHtml option.

Note : When using read range workbook activity uncheck the Add header option, then it will read the data as datatable and store in a datatable. If you check on add header when reading it will not show the headers in the mail.

Hope it helps!!

[ppr (Peter Preuss)]

@hp321

hat needs to be formatted as a table

complete the same style (color, fonts…)?
Or
can it be more simple

A more simple one we can:

• construct HTML code along with styles by a custom modelling
  OR
• using Create HTML Content - Datatable variable

using Create HTML Content

We keep in mind

• the issue with the wrong header line, caused by the activity (till Bug is fixed)
• using CSS on the html template file (manually editing) will be limited on what CSS the email application is supporting

[hp321 (ap)]

Thank you!
Is there any way to make this look a little friendlier? Something like excel…
This is what I get:

[mkankatala (Mahesh Kankatala)]

Hi @hp321

→ Read Range Workbook

In Properties of Read Range remove the check of Add Headers.

Output-> dt_Table

→ Create HTML Content-> Open Editor

→ Use Send Outlook Mail Message to send email check mark IsBodyHTML in the properties panel

Output:

Workflow:

Hope it helps!!

[mkankatala (Mahesh Kankatala)]

I hope you find the solution for your query, If yes Make my post mark as solution to close the loop, else happy to help… @hp321

Happy Automation!!

[hp321 (ap)]

@ppr , thanks for the tips.
can you please elaborate on how to make the table look more like am excel table? not just a plain black and white table…
thank you

[ppr (Peter Preuss)]

Create HTML Content will work with a template file referenced here:

there we can try some reformats by adding CSS definitions, but not all will be supported (e.g. even, odd row formating rules)

@ppr

using CSS on the html template file (manually editing) will be limited on what CSS the email application is supporting