Getting Outlook email from subject and date

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

“@SQL=”“”" like ‘%One-Time Password%’"

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

1 Like

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

Cheers @fflattery


Getting the below error

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


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.