How to paste dynamic excel table into body of send email activity?

Help Activities
1

Dear Experts

I need to paste the excel table into send email body(HTML)
Since the table detail is different in each run, so it should be a variable
But nothing pop up when I click “Add data values”
May I know how to make it happen?

PS: Requester not accept table in attachment

image
image794×363 11.5 KB

image

image
image539×630 20.1 KB

image
image1683×131 15 KB

Thank you for your help in advance :grinning:

2

I already upgrade mail.activity package to latest version
It should pop up sth like below when I click “Add data values” so that I can save datatable variable

But nothing happen when I click it
What is wrong???

image
image981×559 18.9 KB

3

Hi @yangyq10

The image depicts a workflow sequence in UiPath that reads data from an Excel file and sends it via email using the Outlook app. (Captioned by AI)
The image depicts a workflow sequence in UiPath that reads data from an Excel file and sends it via email using the Outlook app. (Captioned by AI)818×1637 69.5 KB

The image shows an HTML content editor window with a draft email that says, "Hi Team, Please find below {{Table}} Regards," and options to save or cancel at the bottom. (Captioned by AI)
The image shows an HTML content editor window with a draft email that says, "Hi Team, Please find below {{Table}} Regards," and options to save or cancel at the bottom. (Captioned by AI)992×560 11.9 KB

Click on Add data values and then Map data value

An email template in an HTML editor with placeholder text and highlighted tool options for adding data values and mapping data values. (Captioned by AI)
An email template in an HTML editor with placeholder text and highlighted tool options for adding data values and mapping data values. (Captioned by AI)889×479 32.9 KB

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

The image shows an HTML content editor with a mapping data values window open, where a table value is being configured and highlighted options include "Table" and "{} DT". (Captioned by AI)
The image shows an HTML content editor with a mapping data values window open, where a table value is being configured and highlighted options include "Table" and "{} DT". (Captioned by AI)849×479 43.3 KB

Regards,

4

@lrtetala I think sth wrong with my UiPath :cry:

5

@yangyq10

Can you try to delete that activity and re add it once

6

@lrtetala I try but it doesn’t work. Here is the sample for your reference

Sample.zip (140.3 KB)

7

@lrtetala

I know what happen, I need to maximize the window first…

8

@yangyq10

It’s working please try this

The image displays an automation workflow sequence that opens an Excel file, reads a specific range from it, and then sends an email using the Desktop Outlook App with the extracted data as an attachment. (Captioned by AI)
The image displays an automation workflow sequence that opens an Excel file, reads a specific range from it, and then sends an email using the Desktop Outlook App with the extracted data as an attachment. (Captioned by AI)818×1594 69 KB

Sample (1).zip (151.8 KB)

Output:

An email containing a table of purchase order data with fields including purchase order number, result status, PO amount, quantities, and unit prices. (Captioned by AI)
An email containing a table of purchase order data with fields including purchase order number, result status, PO amount, quantities, and unit prices. (Captioned by AI)1178×678 28.6 KB

Regards,

1 Like
9

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