How do i copy and paste table from excel to outlook email body?

Help Studio
1

Hi guys, im not sure how do i copy table from excel sheet to paste into the outlook email body. Since im using the send outlook mail message how do i do that? Do i need to convert my excel file to html?

Below is just a reference of how its gonna flow but i still need to send a table with data out to the companies

image
image795×468 20.6 KB

2 Likes
2

Hi @SIM_JUN_HUI_BERTRAM_CSOD

you could use any of these two packages,

It will read data from excel and convert into html table (with cell color and font color)

It has the activity called convert to html table (datatable to html table)

Pass html table string we are getting from the activities output to send outlook mail message activity and tick isBodyHtml

image
image346×577 17.5 KB

3

Hello @SIM_JUN_HUI_BERTRAM_CSOD,

Please see attachment… that will solve your requirement.
_Test.xaml (14.3 KB)

Cheers,
Pankaj

4

How do i go about to put the data in the body? im quite lost lol
Also i have declared ExcelDT as a data table is it correct?

image
image787×499 13.8 KB

5

Assign some variable to convert to Html table output property,

and then pass the variable to body of send outlook mail message activity

6

Ohh got it to work already thanks its very nice

7

Thank you , if the issue is resolved please mark it as solution so it will help others as well…

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.