Outlook VBO is not Filtering by Sender Email

[KevinGutierrez]

I tried filtering by Sender Name, by subject, by unread, by read and is working
But If I filter only by sender email, is not working.
Also I tried with Advanced DASL query and is not working.

Any Idea?

------------------------------
Kevin Gutierrez
Professional Process Engineer
Fiserv
America/Costa_Rica
------------------------------

[CraigFarley]

Hi Kevin

I don't have an exact answer - I found a lot of the filtering to be quite unreliable and there definitely seem to be some issues with it - but what helps is if you use the get emails to get real examples and then copy directly from that collection to use in a filter

------------------------------
Craig Farley
Partner Apps Manager
IPI
Europe/London
------------------------------

[PaulBranson]

Hi Kevin,

I ran into this one a while ago.  Outlook made a change at some point, so I believe it's down to what version you're using.  

Open up your Outlook VBO, go to the Get Received Items (Basic) tab, look for the Sender Email decision, open the associated Filter Expression, and change senderemail to fromemail.  See the associated attachment for a visual.

Hope this helps,
Paul

------------------------------
Paul Branson
Sr. Solution Engineer
Blue Prism
America/New_York
------------------------------

[KevinGutierrez]

Thanks Craig, this is the only solution that I found!
Thanks!

------------------------------
Kevin Gutierrez
Professional Process Engineer
Fiserv
America/Costa_Rica
------------------------------

[KevinGutierrez]

Thanks Paul, I already did this change, but is still not working. Also if I use the advance action

------------------------------
Kevin Gutierrez
Professional Process Engineer
Fiserv
America/Costa_Rica
------------------------------

[AntonHosang1]

For filtering by 'sender' email address, you should use "urn:schemas:httpmail:fromemail" instead of "urn:schemas:httpmail:senderemail", since most times you actually want the 'from' address.

The senderemail may well be a batch-sending account of a company etc.
Moreover, according to the standards, senderemail should remain empty if the from address & senderemail are the same(so it's probably blank a lot of the time!!). And senderemail should only be there when it differs from the from(so it would be the company batch-mailer address - which you DON'T want!!)

The "Get Received Items (Basic)" Action in the Outlook VBO should be changed to reflect that as most probably you will have no interest in the sending address if it is different.

This is something we have done in our customised VBO offerings.

------------------------------
Anton Hosang
RPA Developer
Smart Automation Services
Europe/London
------------------------------

[ZengxinWu]

I have the same issue, but this method is not working.

------------------------------
Zengxin Wu
------------------------------

[AmiBarrett]

This came up elsewhere, and I found a solution. This thread came up during my search, so I thought I'd share the fix I found.

On the calculation for the sender e-mail filter, change the value to:

[Filter Expression]&" AND urn:schemas:httpmail:fromemail ci_phrasematch '"&Replace([Sender Email], "*", "%")&"'"​

------------------------------
Ami Barrett
Automation Developer, Team Lead
Blue Prism
Plano, TX
------------------------------