Hi,
I have an outlook email that contains in the email body some text as well as a table.
The table has 2 columns and a variable about of rows.
I already have the email loaded using the MS Outook VBO.
What I need to do now is the following:
I need to search the table within the email body for specific terms like - "Name", "Address", "Salary", etc then pull out it's respective value which is stored in the next cell, same row.
This is what I'm thinking, but not sure how to do step 2 in blue prism:
1) Once email is loaded
2) Find the cell that contains the term I'm looking for in column 1, then pull it's respective value from column two - on the same row.
3) The value from column 2, will be set into a data item and used through the rest of the processing.
4) Find and retrieve value for the next term.
Can any one offer how to do this?
Thank you in advance!
I have an outlook email that contains in the email body some text as well as a table.
The table has 2 columns and a variable about of rows.
I already have the email loaded using the MS Outook VBO.
What I need to do now is the following:
I need to search the table within the email body for specific terms like - "Name", "Address", "Salary", etc then pull out it's respective value which is stored in the next cell, same row.
This is what I'm thinking, but not sure how to do step 2 in blue prism:
1) Once email is loaded
2) Find the cell that contains the term I'm looking for in column 1, then pull it's respective value from column two - on the same row.
3) The value from column 2, will be set into a data item and used through the rest of the processing.
4) Find and retrieve value for the next term.
Can any one offer how to do this?
Thank you in advance!