cancel
Showing results for 
Search instead for 
Did you mean: 

Get Received Mails using Some specific part of Subject

AbhijitPatil
Level 3
Hi,
I am using get received mails in Microsoft outlook VBO.
I want to retrieve mails using subject line, but not with whole line.
I need to retrieve with some specific part of that subject line. When I use some of the part then it is showing item count zero.
what should be the correct expression for that?
Can I use wildcard? if yes then how?

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

------------------------------
Thank You,
Abhijit Patil
------------------------------
1 BEST ANSWER

Best Answers

Hi Abhijit,

As per your requirement, I sent a test email to myself as shown below:

24469.png

In the Blue Prism end, I am having two data items here called [Subject Part I] and [Subject Part II] as shown below:

24470.pngI am using the below expression in my subject line:

24471.png

Upon running the solution, you can see the below results:


24472.png

Please check the expression once that you are using in your subject parameter for the action: "Get Received Items (Basic)"

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------

View answer in original post

6 REPLIES 6

JoshnaDammala1
Level 2
Hi Abhijit,

You can retrive mails using specific part of subject line. Try using wildcards like "*xyz-12345*"


Thanks,
Joshna

------------------------------
Joshna Dammala
------------------------------

Hi @JoshnaDammala,
Thanks for the reply.
It is working fine.
But actually xyz is a data item and 12345 is also different data item.
when I used data item, it is showing zero count and when using above format it is working fine.
Could you please suggest how to do with data item.

Thank you

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

Hi Abhijit,

As per your requirement, I sent a test email to myself as shown below:

24469.png

In the Blue Prism end, I am having two data items here called [Subject Part I] and [Subject Part II] as shown below:

24470.pngI am using the below expression in my subject line:

24471.png

Upon running the solution, you can see the below results:


24472.png

Please check the expression once that you are using in your subject parameter for the action: "Get Received Items (Basic)"

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------

Hi @devneetmohanty07,

Thanks a lot for taking so much effort and explaining it clearly with Screenshots.
It is working fine.

Thank You

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

Thanks a lot for your kind words @Abhijit Patil 🙂

Glad your query got resolved. Please mark the answer as the best answer if your query has been resolved so that others can easily navigate to the mentioned solution. in case they face any similar issues in future. 🙂

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------

Hi @devneetmohanty07,

Marked your answer as Best Answer.​

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