topic How to read an email using MS Outlook VBO in Product Forum

How to read an email using MS Outlook VBO

RajashekarReddy — Fri, 17 Jan 2020 19:09:00 GMT

Hi,

I'm trying to read an email body contains information about Organization name, location, date and other fields using MS Outlook VBO. I should extract the required information like Organization name, location, etc. It should all happen dynamically without spying the elements. Can anybody please elaborate on this process?
I'm using blue prism v6.5

Regards
Rajashekar Reddy

------------------------------
Rajashekar Reddy
------------------------------

RE: How to read an email using MS Outlook VBO

AmiBarrett — Fri, 17 Jan 2020 20:21:00 GMT

If it's a standard format with reliable strings at the start and at the end, you can use the Mid() and InStr() functions to find the information.

Ex:
----------
FirstName LastName
PhoneNumber
Address
Org
----------

If the information is in a consistent format, you can (in the above example) find the position of the first ---- header, then split out the information by each newLine.

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Richardson, TX
------------------------------