Send excel data as html via outlook

[sshitol (sush)]

Hi,
I have two excels, I want to share table through email.
Attaching excels along with email format
student.xlsx (9.2 KB)
clg.xlsx (8.8 KB)

[ashokkarale]

@sshitol,

Read the excel files with Read range activity and use below solution to send the datatable through email body.

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

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 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)] 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 a…

Thanks,
Ashok

[batthula.p949]

Hi @sshitol

To share tables from two Excel files through email in UiPath, you can follow the steps below. This includes reading the data from the Excel files, formatting the data into an HTML table, and then sending it via email.

Steps to Send Tables from Two Excel Files via Email in UiPath:

1. Read Data from Excel Files:
   Use the Excel Application Scope activity to open each Excel file.
   Use the Read Range activity to read the data from the specific sheets or ranges into DataTable variables.

2. Convert DataTables to HTML Tables:
   Convert the data in each DataTable to an HTML table format. This can be done using custom code or by manually concatenating strings to form the HTML structure.
   You can include this code in an Invoke Code activity or use a simple string manipulation if the DataTables are small.

3. Prepare the Email Body:
   Create the email body in HTML format, incorporating the HTML tables you created from the DataTables.

4. Send the Email:
   Use the Send SMTP Mail Message or Send Outlook Mail Message activity to send the email.
   Configure the properties as follows:
   To: The recipient’s email address.
   Subject: Subject of the email.
   Body: The HTML content prepared above.
   IsBodyHtml: Set this to True to enable HTML formatting in the email.
   Attachments: Optionally, attach the original Excel files using the Attachments property if needed.

Thanks,
Purushotham

[sshitol (sush)]

i tried its working but allignment is not proper… headers coming in center while other rows are coming left

[ashokkarale]

@sshitol,

You may try this option then.

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

@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)] 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)] Regards,

Thanks,
Ashok