Extract only a table present in email body

Hi All,

I am trying to read a table from email body ,but it is coming as text only.
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 say in excel.
Any suggestions?

Hi

  1. save the email as a .mht file
  2. use StartProcess to open the file
  3. scrape the data from the table in the email into a datatable
  4. write datatable to excel

Hope that helps.

3 Likes

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