Not able to Filter the email received today


#1

Hi, I want to read the email if it has been received today and subject is ABC. I have stored ABC in a variable. Below is the logic I have used in get outlook email address. I am not getting the desired output. Please can you help.

“[Subject]=” + EmailSubject AND + [ReceivedTime] >= + today.ToString(“MM/dd/yyyy hh:mm tt”)


#2

There a few solutions in the forum on this topic.

Another Solution is :

"@SQL= %today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject='"+EmailSubject+"'"

Today : %today(urn:schemas:httpmail:datereceived)%

Yesterday : %yesterday(urn:schemas:httpmail:datereceived)%

More Info:

https://msdn.microsoft.com/en-us/library/bb147584(v=office.12).aspx


Get list of mails but "Mark as Read" one by one