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.


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


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


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

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.


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.


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 …


Custom activity to extract tables from email:

It takes mailmessage as an input and returns a dataset with all the table content in the email.