Extracting tables from email body in outlook app

[Manish_Prasad_manishp]

Hi All,

Need help in extracting multiple tables from a outlook email body. The number of tables is not common. It changes based on the email received. I tried using data scraping but it only shows the result of the screen visible.

[nikhil.girish]

Hi @Manish_Prasad_manishp
kindly refer below link

Extract Table from Outlook

There was another solution in the same link… i am posting the link for it below. Did u try that? Just copying the whole thing and pasting it to an excel? I tried this once when i wanted to extract a table from a word and put it into excel in the same way without any changes. I did a recording where i sent hot keys to copy(ctrl + c) the whole doc and opened an excel and pasted it (ctrl + v) and saved it.

hope this helps

Thanks

[Gokul001 (Gokul Balaji)]

Hi @Manish_Prasad_manishp

Welcome to community

Refer the link for more info

Extract Tables from Mail - RPA Component | UiPath Marketplace

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

Regards
Gokul

[Manish_Prasad_manishp]

Do you have the package name. As i am not able to find this custom activity

[Gokul001 (Gokul Balaji)]

HI @Manish_Prasad_manishp

Have a look on the thread

Read all the tables into a dataset which are in the current mail in outlook

Hi @Venkatesh_N, Please find a custom activity to extract all the tables from email: https://go.uipath.com/component/extract-tables-from-mail-839f39 It would return all the tables from email into a data set. If you know that your email can have fixed number of tables, you can simply use ds.tables(0),ds.tables(1) and so on. If the number of tables in the email are also dynamic and it is a chain mail, we need to modify the mailmessage object as a workaround. Please find attached xaml and le…

Go To → Manage Package → ExtractTable (Install → Save)

Look into Screenshot

Regards
Gokul

[Manish_Prasad_manishp]

Thank you Gokul. However looks like this activity is not working for me as the tables in my email dont have borders and due to which this activity is not finding the table. I tried this with other email which has borders in table and it works.

Can anyone suggest me any other way. I tried data scraping but that is only scraping the visible part of the screen but not the whole email.