cancel
Showing results for 
Search instead for 
Did you mean: 

Get Received Mails using Some specific part of Subject

AbhijitPatil
Level 4
Hi,
I am using Get received items in Microsoft outlook VBO.
I want to retrieve mails using subject.
But do not with whole subject line. I am going to retrieve mails with some specific part of that subject line.
But it is showing item count zero.
What should be the correct expression for that. Can I use wildcard? if yes then how?

Thank You,
Abhijit

------------------------------
Abhijit Patil
------------------------------
4 REPLIES 4

Hi

Yes you can use part of the subject line to identify the item you are looking for you just need to include a wildcard in the appropriate places. For example if you full email subject is "welcome to blueprism world 2021" I can search for this using only the blueprism world with the syntax "*blueprism world*" so the text before and after can be anything and it will return all items with blueprism world in the subject.

Hope this helps 🙂

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

Hi @Michael ONeil,

Thank you for the reply,

Format of subject line :  "Abhijit - xyz-123456-12162021-0001.xls"
Need to retrieve with:   "xyz-123456"    or  "123456 only"

But actually xyz is a data item and 123456 is also different data item.
when I used data item, it is showing zero count and when using above format you mentioned, it is working fine.

Could you please suggest how to do with data item.

Thank You​

------------------------------
Abhijit Patil
------------------------------

Hi

If you want to use data items you just need to include the text before and after data item. If DataItem1 contains xyz and DataItem2 contains 123456 then the subject line in the outlook action would look something like this "*"&[DataItem1]&"-"&[DataItem2]&"*" which would result in "*xyz-123456*"

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

Hi Michael,
Thanks a lot.
It is working fine.

------------------------------
Abhijit Patil
------------------------------