Embedding excel data as a table into email body using studiox

[Mariam_Al_Ashwan]

Hi ,
Currently ,I am building escalation system by sending email which its body contains excel data as a table formate. see below for more clarification.

Kindly advise

[Yoichi]

Hi,

We can achieve it as the following step.

First, read table from excel sheet using ReadRange activity (with UseExcelFile)

Next, put SendMail activity or CreateHTMLContent activity and click “OpenEditor”

Click Add data values at top-right corner
Choose “Table” from AddValue dropdown and set variable from ReadRange activity as Value property.
Finally, insert it into mail body via AddValue menu.

Regards,

[Mariam_Al_Ashwan]

Thanks for your support sir😊