How to paste the excel table into the outlook mail body

[anjani_priya]

How to paste the excel table into the outlook mail body where range is not fixed and the range of excel changes. i should only paste upto the filled data.

[ashokkarale]

@anjani_priya,

There is no predefined activity as such but try these workarounds.

Insert Excel table data into email body

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] [image]

How to send dynamic and multiple table in email body

Hi @satish.rathi59 You can use Create HTML content activity to create the body and insert table and save the output in a Variable. Pass this output in Body field in Send outlook mail message or Send SMTP activity and check the IsBodyHTML option in properties. → Use the Read Range workbook activity to read the excel and store in a datatable variable. → Click on the Open editor option in Create HTML content activity a window popsup. → In that window, click Add data values, and click on Add …

[Parvathy (PS Parvathy)]

Hi @anjani_priya

Check the below thread

Insert Excel table data into email body

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)] [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)] [The image shows an HTML content editor wi…

Hope it helps!!

[Shwetha_Ningappa]

@Anjani_Priya
you can use the vba/vbs approach

[anjani_priya]

I have format in the excel dt, in the attached thread, if I do the same, I’m not getting the format. how to resolve this

[ashokkarale]

@anjani_priya,

The format you will have to code using html css style attributes.

[anjani_priya]

I have tried with html

but I’m getting like these symbols and boxes

[ashokkarale]

@anjani_priya,

Can you share the sample input xlsx file. Let me try.

[anjani_priya]

@ashokkarale yeah sure
Rows and columns are dynamic
Book2.xlsx (9.3 KB)