How to extract specific data from an outlook email

[kaavya (Mamtha)]

hi!
i want to extract table from body of an outlook email save it ina excel file and further send it to respective mail id and in the process i have reached here like used save mail message activity and opened in a browser but i couldnt extract table using scraping so can anybody help me in solving this

please any help would be appreciated

thanks,
kaavya

[NIVED_NAMBIAR (NIVED N)]

Hi @kaavya

Did you tried to save it in HTML format and then open by open browser and then scrap it ?

Or another way is to use the activity for extracting tables from email to save it into excel directly

Regards,
Nived N

[kaavya (Mamtha)]

can you let me know the activity name? because scrape wasnt working in my case @NIVED_NAMBIAR

[NIVED_NAMBIAR (NIVED N)]

Hi @kaavya
Try this please

Extract Tables from Mail - RPA Component | UiPath Marketplace

Mark it as solution if it helps you
Regards,
Nived N

[kaavya (Mamtha)]

two activities were missing @NIVED_NAMBIAR

thanks
kaavya

[NIVED_NAMBIAR (NIVED N)]

Means?

[kaavya (Mamtha)]

two of the activities were missing/invalid from the workflow @NIVED_NAMBIAR

[NIVED_NAMBIAR (NIVED N)]

Hmm seems like a version mismatch

Let me try from my side and let you now

[kaavya (Mamtha)]

thank you @NIVED_NAMBIAR

[NIVED_NAMBIAR (NIVED N)]

Hi @kaavya
I found a blog regarding this
check this
https://rpageek.com/get-table-from-email-with-uipath/

Regards,
Nived N

[NIVED_NAMBIAR (NIVED N)]

If it does not work, we had to go for c#/vb net /python coding to extract table out of pdf

[kaavya (Mamtha)]

thank you for the help! i will try and let you know @NIVED_NAMBIAR

[kaavya (Mamtha)]

i got this error
Extract data tables from HTML: Could not load file or assembly ‘HtmlAgilityPack, Version=1.8.7.0, Culture=neutral, PublicKeyToken=bd319b19eaf3b43a’ or one of its dependencies. The system cannot find the file specified.

@NIVED_NAMBIAR

[NIVED_NAMBIAR (NIVED N)]

hI @kaavya
It is working fine for me
seems like a version problem for you. Can u check at the dependency section?

[kaavya (Mamtha)]

what should i check at dependencies section? @NIVED_NAMBIAR

this is how dependencies looks like in my project

[vinithareddyk123 (Vinitha)]

Hi @kaavya

Please try below steps and let me know if its working or not

Download the below activity

MailMessages is the out of GetOutlookMail activity
Result is the out of Extract tables from email activity

Thanks

[kaavya (Mamtha)]

still getting error @vinithareddyk123

[vinithareddyk123 (Vinitha)]

The activity you have used is different please use Extract table from email activity ( This Activity is available if you download the package which I have mentioned earlier)

[kaavya (Mamtha)]

thank you so much @vinithareddyk123 I got the output

thank,
kaavya