How to extract table data from mail body?

Help Activities
, ,
1

I need to extract data from table from mail body. I used extract tables from email activity. but it is not extracting properly. Please help me to solve this.

2

Hi,

Could you please refer the below custom activity from Uipath market place. It might help your requirement. Thanks.

1 Like
3

@kirankumar.mahanthi1 Already i tried that custom activity . All the data are stored into “A” column only. Data are not extracted properly.

4

Hi

There are multiple approaches to read a DATATABLE from a mail body
Like data scrapping or converting the HTML mail body to DATATABLE

Have a view on this thread for multiple approaches

Or
This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it

If you using this component
Then the steps involved will be like

image

image

In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the email and convert it into a string.

image
image311×706 13.4 KB

Cheers @BNK

2 Likes
5

Hi,

I think we don’t have much options for this requirement. There is one approach like

  1. Get the mail body from the mail items.

  2. Convert that text to a html file.

  3. Open that html table in browser.

  4. Using extract table or extract structure activity to extract the data into data table.

  5. Use write range to write data back to excel.

Sharing my thought with the above high level steps.

And also please refrer the below link it is having some different approach to achieve the requirement you mentioned.

rpageek.com is available for purchase - Sedo.com.

2 Likes
6

Hi @kirankumar.mahanthi1
I am not able to do step 3. because After completion of step 2 the data is not in table format.

7

Hi,

Are you able to save as the text file to html. You can use open browser activity or start process activity to open in browser.

8

Hi @kirankumar.mahanthi1

I am able to save the text to html. But now the data not in table format.

9

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