How to Copy Excel table to Outlook body

[Vincent_Nuestro]

Hi, I want to put or Copy my excel table to my email Body.

Here is My Excel, This is Dynamic Data, sometimes its more than one or two data in the table.

I wanted to copy the table and put it in my email template.
Here is my Email Template.

My expected output should be like this.

Thank you in advance
-Vincent

[ermanoj3101 (MANOJ)]

Hi @Vincent_Nuestro ,

You can follow below video

How to create table in mail body in UiPath?

For reference

Dynamic name in email body with email message in html

Hi, I want to achieve a task of email, below is my issue I have an excel with column name “Name” and “Email id” and i have to send email with email body having name from the excel with my message in html format like below Dear +record.Item(“Name”).ToString, [image] On this special day, We wishes you very Happy Birthday! May you be showered with blessings and happiness!!! With warm wishes, Team I have created a flow attaching with this. [Main] I want the recipient to receive be…

[Vincent_Nuestro]

Hi @ermanoj3101

Why i am getting error in my For each
Error Says : ‘)’ expected

[sai_krishna_somisetty (sai krishna)]

Hi @Vincent_Nuestro,

You can read the excel and store data in DataTable.

you can add this activity package to your project(from manage packages), which takes DataTable as input and gives result as String.

DataTable.to.HTML.String.1.0.2.nupkg (23.8 KB)

While sending the mail check IsBodyHTML propertie like below

Thanks,
saiKrishna

[ermanoj3101 (MANOJ)]

Hi @sai_krishna_somisetty ,

Try to use “for each” as shown below

foreach (DataRow row in FilteredDt.Rows)
{
    
}

[prasath_S]

Hi @Vincent_Nuestro

Please use my package,

DataTable Manipulation - RPA Component | UiPath Marketplace

There is an activity called convert to html which has lot of customization as well

Thanks

[prasath_S]

Hi @Vincent_Nuestro

If the issue got resolved,please mark it as solution and close the thread so it may be useful to others in the future.

Thanks

[Vincent_Nuestro]

Hi @prasath_S

Im still learning this package, can you recommend me how to use this properly to resolve my issue?

[prasath_S]

@Vincent_Nuestro yes sure

Please try the below steps,

1. Read the data in the excel sheet using read range and store it a datatable variable name dt.

2. Install the package and you will find 15 activites inside this package for now please use convert to html activity.

3. Pass the datatable dt as input for the activity and store the output in a string variable named result.(create one if it don’t have already)

4. Use any send mail activity and pass the result in the body in the property.

5. Change the font, font color,font size, header and border as you want in the properties panel of the convert to html activity.

Please let me know if anything required.

Thanks

[prasath_S]

Hi @Vincent_Nuestro have you tried it?

Thanks

[prasath_S]

Hi @Vincent_Nuestro

Thanks for using the package, and from the screenshot I can see that the number of columns are more, because the outlook table is not having as many column size as excel,it will auto adjust to the screen size.the outlook tables has its limitations of how many columns it can display without breaking it’s structure as you have.

There are some ways we can test it,

1. If you can reduce some columns it will align perfectly.

2. If you see the table in bigger monitor instead of a laptop it will adjust the table contents to the screen size.

As for I know it will break the alignment it has more columns (also each column size is big) and see the content in small screen (like laptop)

Thanks

[Vincent_Nuestro]

I see, Got it. Thank you So much:)