How to extract specific data from an outlook email

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

1 Like

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

1 Like

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

Hi @kaavya
Try this please

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

1 Like

two activities were missing @NIVED_NAMBIAR

thanks
kaavya

Means?


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

Hmm seems like a version mismatch

Let me try from my side and let you now

1 Like

thank you @NIVED_NAMBIAR

Hi @kaavya
I found a blog regarding this
check this

Regards,
Nived N

1 Like

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

1 Like

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

1 Like

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

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

what should i check at dependencies section? @NIVED_NAMBIAR


this is how dependencies looks like in my project

Hi @kaavya

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

Download the below activity
image

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

image

Thanks

1 Like

still getting error @vinithareddyk123

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)

1 Like

thank you so much @vinithareddyk123 I got the output

thank,
kaavya

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