How to get Data table from body of email?

_aurelie_

New Member
Hi,
I checked the existing threads but didn't find the answer I need, please if someone has solution.
I have to get a table from an email. There are 2 columns, each item from the 2nd column will be used in some fields of an application, I want to get the 2 columns and each line in a collection. The only thing I manage is getting a collection with the fields from Object MS Outlook Email VBO / action "Get Received Items (basic)" wich are "EntryID", "To", "CC", "Subject", "Body" etc.
Thank you for helping
 

_aurelie_

New Member
Thank you, this works manually, but I don't understand how to do this from the object studio in Blue Prism,
can you help me ?
what object and what action should I use ?
Thank you
 

Sachin_Kharmale

Active Member
If you are getting the body in html format then based on the string operation you can able to fetch the table data.
eg.
if html mail contains html table code like,

HTML:
<table id="t01">
  <tr>
    <th>Firstname</th>
    <th>Lastname</th>
    <th>Age</th>
  </tr>
  <tr>
    <td>Eve</td>
    <td>Jackson</td>
    <td>94</td>
  </tr>
</table>
then just using string operation fetch the data from td and tr tag as per your requirement.
 

_aurelie_

New Member
Thank you Sachin, as I am very beginner with Blue Prism, I have to ask how to get the body of email in HTML format from Blue Prism, can I do so by using MS OUTLOOK email VBO ? and what action ?
Thank you,
aurelie
 
Top