topic Outlook VBO is not Filtering by Sender Email in Product Forum

Outlook VBO is not Filtering by Sender Email

KevinGutierrez — Thu, 09 Apr 2020 00:53:00 GMT

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
------------------------------

RE: Outlook VBO is not Filtering by Sender Email

CraigFarley — Thu, 09 Apr 2020 07:32:00 GMT

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
------------------------------

RE: Outlook VBO is not Filtering by Sender Email

PaulBranson — Thu, 09 Apr 2020 13:31:00 GMT

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
------------------------------

RE: Outlook VBO is not Filtering by Sender Email

KevinGutierrez — Thu, 09 Apr 2020 17:18:00 GMT

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

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

RE: Outlook VBO is not Filtering by Sender Email

KevinGutierrez — Thu, 09 Apr 2020 17:19:00 GMT

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
------------------------------

RE: Outlook VBO is not Filtering by Sender Email

AntonHosang1 — Fri, 10 Apr 2020 11:15:00 GMT

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
------------------------------

RE: Outlook VBO is not Filtering by Sender Email

ZengxinWu — Mon, 30 Nov 2020 10:34:00 GMT

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

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

RE: Outlook VBO is not Filtering by Sender Email

AmiBarrett — Thu, 14 Jan 2021 14:19:00 GMT

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
------------------------------