How to read an email using MS Outlook VBO

[RajashekarReddy]

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
------------------------------

[AmiBarrett]

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
------------------------------