Filter outlook mail

[TUSHAR_DIWASE (TD)]

Hi,
How to filter outlook mails by subject = complete and received date= today

In subject , complete is fixed keyword. Their can be any word before or after. So have to use “like”

I want to use filter property of get outlook mail message

[nikhil.girish]

Hi @TUSHAR_DIWASE

Kindly refer my below solution

Hope this might help you

How can i search specific mail id in outlook and get latest unread mail

so what is your requirement you want to filter by subject or by sender name for sender name [image] “[SenderEmailAddress] = '”+your variable+“'” for subject “[Subject] = '”+your variable+“'”

For recieved time/date sample syntax

" [ReceivedTime] >= ‘02/23/2022’ AND [ReceivedTime] <= ‘02/25/2022’ "

One more method by not use filter property

Use get outlook message activity

Drag a for each activity

So for each. Item in mail message

Put a if condition with statement below

Item.subject.contains(“Complete”)

Then do your desired step
Else. Skip

Thanks

[Karuna (Karuna Devanagavi)]

@TUSHAR_DIWASE

Try this

[TUSHAR_DIWASE (TD)]

Sorry bu not working

[TUSHAR_DIWASE (TD)]

Thanks but it is not giving any filter mail eventhough their is mail for today date

[nikhil.girish]

@TUSHAR_DIWASE
let me provide you a sample code

[nikhil.girish]

Sequence.zip (1.9 KB)

Hi @TUSHAR_DIWASE

hope that helps

[Gokul001 (Gokul Balaji)]

hI @TUSHAR_DIWASE

Check out this thread

Get Outlook Mail Messages Filter Filter By Subject

I want to use the filter option on the Get Outlook Mail Messages activity. I am trying to get all emails that contain the subject “Billing”. What I currently have is “[Subject]=‘Billing’” but this does not return anything. What am I doing wrong? I do not want to use a for loop to iterate over emails unless I can mark the ones without Billing as unread. Thank you SOLUTION: "@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'" OR "@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E""…

Regards
Gokul

[TUSHAR_DIWASE (TD)]

@Gokul001 ,thank but i am looking to use filter property to filter mail based on today date and subject

[TUSHAR_DIWASE (TD)]

@nikhil.girish thanks for the reply. Can we use filter property to achieve the same.
filter based on received date= today and subject=“Complete”

[nikhil.girish]

yes we can @TUSHAR_DIWASE

but did tht code serve your purpose

[TUSHAR_DIWASE (TD)]

yes. indeed. but i am looking to achieve this using filter property

[Gokul001 (Gokul Balaji)]

@TUSHAR_DIWASE

today date and subject

Then try this filter
“@SQL=%today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject Like '%” Complete"%'"

Hope this Helps

Regards
Gokul

[TUSHAR_DIWASE (TD)]

Getting error

[Gokul001 (Gokul Balaji)]

try this one

“@SQL=%today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject Like ‘%Complete%’”

Regards
Gokul

[TUSHAR_DIWASE (TD)]

thanks but getting error -Get Outlook Mail Messages: Cannot parse condition. Error at “@SQL=((%today(urn:schemas:httpmail:dater…”.

[nikhil.girish]

I suggest you to better go with this approach shared earlier via code rather than trying to filter in activity itself , to avoid any issues @TUSHAR_DIWASE

[Gokul001 (Gokul Balaji)]

Okay this one

“”"@SQL=urn:schemas:httpmail:subject Like ‘%Complete%’ and [Received] >= " + DateTime.Today.ToString(“Your Path “)+””

Regards
Gokul