Read from table inside outlook email

Hi all,

I wanted to automate outlook emails to avoid wasting to much time in moving emails to a particular folder.
To make sure I could automate it correctly I copy a table inside the email that I send out. When the email comes back, the automation will check the table, find a text in it (BIN nr) and then move it to the correct folder.

The table looks like below:

BIN nr: 1234567
Company name: This Ltd.
Status: New
Rating: 1

The table will have always be at the bottom of the email. It would be great if I could have it read at least the Rating first and the BIN nr. So the macro could find the correct folder.

Any ideas how to read from a table?

Greetings.

Hi Norie,

So far I manage to find the below code:

Please Login or Register  to view this content.

The email should be in plain text but some one could also send in HTML I guess (could this be problematic?)

Greetings.

Hi,

In the above code I can manage only to get the contents of the lines, but it needs to find a word instead and then look at the next word to the right, so it will use that word to find a folder.

Greetings.

Hi Norie,

No clue how to use the above code.
I tried like this:

Please Login or Register  to view this content.

but the "pos" gives only 0

Any idea how I could locate the word right to "Risk rating:"

Greetings.

Hi Norie,

I found this code that can get the value to the left I look for, but if it could be adjusted to get the next word right to it, I could be lucky :-)

Please Login or Register  to view this content.

Greetings.

Hi Norie,

Some ideas?

Greetings.

Hi,

How can I combine the below code with the above to create a path where the email will be copied?

Please Login or Register  to view this content.

It should take the "Rating" "BIN_nr" and "Company_Name" so it could construct a path like this: C:\my path\High\1234567_Company Ltd

Greetings.

Hi,

I managed even the below. Now I only need it to not to copy the emails to the folder if there is no BIN nr in the email message.
Where in the code can I put a spy to see if there is no BIN nr and if not, go to next email?

Please Login or Register  to view this content.

Greetings.