Extracting data from Outlook to Excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-19 08:56 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-10-19 08:18 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-10-19 08:27 AM
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
------------------------------
