Insert Excel table data into email body

Help Studio
, ,
1

Hi Team

i am working to send email with some excel table date insert into email body.
i read range in excel and saved to variable. but don’t know how to combine it with text.
how can i do it?

Thank you.

image
image1280×620 32.5 KB

image

2

Hi @wason_ha

Can you try below

The image shows a UiPath workflow sequence that reads data from an Excel file and sends an email using the Outlook desktop app, with specified recipient, subject, and body format. (Captioned by AI)
The image shows a UiPath workflow sequence that reads data from an Excel file and sends an email using the Outlook desktop app, with specified recipient, subject, and body format. (Captioned by AI)818×936 44.9 KB

This image shows an email composition interface with fields for the account, recipient, subject, body (in HTML format), and attachments, with highlighted options for HTML body and opening the editor. (Captioned by AI)
This image shows an email composition interface with fields for the account, recipient, subject, body (in HTML format), and attachments, with highlighted options for HTML body and opening the editor. (Captioned by AI)583×519 14.1 KB

The image shows an HTML content editor window with a draft message to a team that includes a placeholder for a table and buttons for "Save" and "Cancel". (Captioned by AI)
The image shows an HTML content editor window with a draft message to a team that includes a placeholder for a table and buttons for "Save" and "Cancel". (Captioned by AI)992×560 11.9 KB

Click on Add data values and then Map data value

The image shows an HTML content editor with a partially composed email, where a user is in the process of inserting a data table by selecting "Add data values" and "Map data value" from a dropdown menu. (Captioned by AI)
The image shows an HTML content editor with a partially composed email, where a user is in the process of inserting a data table by selecting "Add data values" and "Map data value" from a dropdown menu. (Captioned by AI)889×479 32.9 KB

Click on Add Value and Select Table then pass your data table variable

The image shows a software interface for editing HTML content, specifically mapping data values where a table named "DT" is being added to the content. (Captioned by AI)
The image shows a software interface for editing HTML content, specifically mapping data values where a table named "DT" is being added to the content. (Captioned by AI)849×479 43.3 KB

Note: In Read Range Workbook activity make sure to uncheck Add Headers property

Regards,

1 Like
3

Thank you Lakshman for supporting during weekend.
it is the answer. Thank you!
one more question please, how i can define {{Table}}'s Font and Font size?

4

@wason_ha

Click on below option and write your own code

The image shows an "Edit HTML Content" window containing a draft of an email addressed to a team with a placeholder for a table of data. (Captioned by AI)
The image shows an "Edit HTML Content" window containing a draft of an email addressed to a team with a placeholder for a table of data. (Captioned by AI)989×560 11.9 KB

Regards,

5

Thank you for your help

1 Like
6

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