Getting Outlook email from subject and date

[Automater999]

Hi i have the below which successfully gets the latest email with the subject i want.

“@SQL=”“http://schemas.microsoft.com/mapi/proptag/0x0037001f”" like ‘%One-Time Password%’"

How would i modify this to retrieve the email from todays date

[Palaniyappan (Palaniyappan P)]

Hi
The condition be like this
“@SQL= %today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject like '”+EmailSubject+“'”

Cheers @Automater999

[Automater999]

Hi,

Getting the below error

[Palaniyappan (Palaniyappan P)]

For your case as we have the string directly mention like this without variable

“@SQL= %today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject like ‘%One-Time Password%’ “

Kindly type from your end once and don’t copy from here as the double quotes will change

Cheers @Automater999