Extract table from Outlook Mail body

I am trying to read a table from email body .
What i want is i get only the table and no other email body from the email.
My purpose is to read a value in second column of a table after reading the table from outlook and extracting it to excel.
Any suggestions?
I have already read some related topics but I’m unable to understand that.
If possible pls send sample workflow…

Hi @PrabhuViswa ,

Below are the Steps. Hope it works.

  1. Save the mail attachment as .mht file
  2. Open the .mht file with browser( IE )
  3. Once data is available on webpage - you can use Web Scrapping to Scrape only the table Required.

image
image

For Start Process :
you put : “C:\Program Files (x86)\Internet Explorer\iexplore.exe”
Followed by : Path of .mht File


Mukesh

1 Like

Hi Brother …This my workflow


I’m trying to extract this table from mail body

and then copy it to excel file consider left column as header which is common in all mail body and right column should append below the respective header…And I want to repeat this process with mail has some specified subject…

Your workflow Looks Fine … Few Changes

  1. Update Below Save Message to Save as .mht
    image

image

  1. Update The start process as shown below : To open the downloaded .mht file with IE.

image
you put : “C:\Program Files (x86)\Internet Explorer\iexplore.exe”
Followed by : Path of .mht File

Once Opened in IE , you use web scrapping to srape the data in datatable and save in excel.


Mukesh

After Extracting the datatable I want to convert left side column as header in Excel file and their respective value in right column should append below the header in Excel file.

@PrabhuViswa

Now , I believe you are able to get the Datatable content from email.

  1. Paste the DataTable in Excel.
  2. Now we have to Transpose the First Column to Header - Correct me i am wrong here.

If this is the Case :

Below is the Link I found on Transposing Data Column to Header …


Mukesh

Custom activity to extract tables from email:
https://go.uipath.com/component/extract-tables-from-mail-839f39
It takes mailmessage as an input and returns a dataset with all the table content in the email.

1 Like