Not able to read Email with a specific subject line and within a time frame using a SQL query

[MobashirMd14]

I am trying to read specific mail from outlook within a specific subject line and within a time frame.

I was using below mentioned query which was working fine until sometime back. But now it has stopped working and the bot is not able to read those specific mails.

@SQL=urn:schemas:httpmail:subject LIKE '%Test123%' AND urn:schemas:httpmail:datereceived >='11 January 2025 00:00' AND urn:schemas:httpmail:datereceived<='05 February 2025 15:20'

Can someone tell if they have experienced a similar issue and how did they resolve it?

Thanks in advance.

[SayeedBinAbdullah]

Hi @MobashirMd14 

I ran the exact same query on my machine and successfully obtained the result.

@SQL=urn:schemas:httpmail:subject LIKE '%Test123%' AND urn:schemas:httpmail:datereceived >='11 January 2025 00:00' AND urn:schemas:httpmail:datereceived<='06 February 2025 15:20'

I recommend closing all open instances of the Outlook application. Once closed, reopen the application before running the mentioned query.

Best Regards,
Sayeed Bin Abdullah

[MobashirMd14]

Thanks for the update. I identified the issue, and it was something else.

In this case, bot was not able to get results because mails have been moved to archive folder.

Thanks for your response.

Regards,

Mobashir