Extract Table for a Body email


#1

Hi,
I am trying extrat a table for a body email.

I have looked for similar problems in the forum, but I have not found anything that can solve it. I have tried to extract the body from the email as html, but I am not able to access each cell.

I must bear in mind that the cells may have content, but other times they may be empty.
I do not know if there is any way to extract the table as .csv or how I should handle it in order to access the values ​​located in each cell.

Thank you


#2

Try scrapping…


#3

Use DataScraping Option From the Ribbons To Extract the table

Note: You firstly Need to open the Email in browser (recomeneded IE).


#4

I cant open Email in browser. I don’t have access to it.
I use activities exchange email to read it. And need download o get data from a table inside body.

I have managed to download the email in a .html
But I am not able to scrap the entire table.


#5

Okay So,In this Case You have to use String manipulation techniques and some regex to extract the related information.

Store Mail.Body As a String And do string manipulation in it .