RPA — How to filter Outlook Mails by Sender Email Address in UiPath

While any RPA process, You may be in a situation where you might require to filter Outlook Mail with Sender Email address. There are two ways to do so:

1. Get all Outlook mails and loop through it
2. Get filtered Outlook Mails beforehand

In this tutorial, I will show you how to use filters in the ‘Get Outlook Mail Messages’ activity

Use the below code for filtering with a specific email id :

“[SenderEmailAddress]=’help@santanbarnwal.com’”

Sender Email Filter used in ‘Get Outlook Mail Message’ activity

There might be a requirement where you want to use wildcard search on Sender Address.

Use the below code for wildcard search:

“@SQL=””http://schemas.microsoft.com/mapi/proptag/0x0065001F"" LIKE ‘%@santanbarnwal.com’”

This filter will filter all emails coming from the domain name santanbarnwal.com

Wildcard Filter used in ‘Get Outlook Mail Message’ activity

Happy Automation !!

Get the XAML file from GitHub: https://github.com/santanbarnwal/RPA-UiPath-Workflows/blob/main/Mail_Filter.xaml

Follow me on LinkedIn: https://www.linkedin.com/in/santanbarnwal/

Subscribe to my YouTube channel: https://www.youtube.com/channel/UCoF8-B_MfOCL40szrorbtyQ

My Website: www.santanbarnwal.com

— Santan Barnwal