Extracting data from Outlook to Excel

[GeorgeKattapura]

Hi all,

I am new to Blue Prism and would appreciate some guidance with my scenario for automation. The situation I want to automate is as follows.

Emails are received into a shared inbox with an attachment. The attachment is .msg (outlook email format). I want to be able to open the attachment and extract the following data from the email attachment to Excel is.

Date received
Send email address
Subject line
Body of the email

Firstly, is this possible with the current VBO's available on the digital exchange and which ones?

or

Should I use spying to accomplish this?

------------------------------
George Kattapuram
Project Manager
GAK Services Ltd
------------------------------

[PratyushGarikap]

Hi George,

Sounds like a combination of MS Outlook Email VBO and MS Excel VBO should serve your need. If you are unfamiliar with these objects then I would recommend that you review the Foundation Training in Blue Prism University to get further insight into their usage.

------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------

[AndreyKudinov]

​It should not be possible with mapiex, probably can be done with Outlook VBO and some extra code.

Can also be done rather easy with EWS managed API if you use Exchange (needs extra dlls from microsoft installed).
I actually played with it, but don't have a code ready to do exactly what you ask for - just saving msg files.
https://github.com/aikudinov/BlueprismVBO/blob/master/BPA%20Object%20-%20Exchange%20EWS%20API.xml


------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------