How to use Filter Expression in MS Outlook VBO(Advanced) in Blueprism

MUB

New Member
I have a requirement to read an email where subject and sender will be different all the time.
Only thing that is constant is First part of the subject
For Ex: Plant Name: 1000 --- is the subject.
The text ''Plant Name:'' can be seen in the subject every time and that value is going to change for every mail.

Can I use filter expression of MS OutlookVBO (Advanced) for this requirement or is there any other way?

Thanks in advance..
 

sahil_raina_91

Active Member
I have a requirement to read an email where subject and sender will be different all the time.
Only thing that is constant is First part of the subject
For Ex: Plant Name: 1000 --- is the subject.
The text ''Plant Name:'' can be seen in the subject every time and that value is going to change for every mail.

Can I use filter expression of MS OutlookVBO (Advanced) for this requirement or is there any other way?

Thanks in advance..
You can continue to use the Get Received Items (Basic) Action for this.
In the Subject Input, use "%Plant Name:%"

For Get Received Items (Advanced), try : "@SQL=urn:schemas:httpmail:subject LIKE '%Plant Name:%'"
 
  • Like
Reactions: MUB

MUB

New Member
You can continue to use the Get Received Items (Basic) Action for this.
In the Subject Input, use "%Plant Name:%"

For Get Received Items (Advanced), try : "@SQL=urn:schemas:httpmail:subject LIKE '%Plant Name:%'"
Hi @sahil_raina_91

The subject '' Plant Name: %'' is not case sensitive.It is just accepting whenever all the letters are in lowercase or uppercase.

How to make this as case sensitive ??
 
Top