Help: Outlook Filter

Help StudioX
,
1

Hi all,

I need help with an Outlook filter so that I may extract emails with the subject line “Doctor Report” from the current month to the first day of the month that comes next.

Thanks

2

Hi @Random_Bot ,

Try with below filter, hope it works for you :slight_smile:

"@SQL=(""urn:schemas:httpmail:subject"" LIKE '%Doctor Report%' AND ""urn:schemas:httpmail:datereceived"" >= '01/"+now.ToString("MM")+"/"+now.ToString("yyyy")+"' AND ""urn:schemas:httpmail:datereceived"" <= '01/"+Now.AddMonths(1).ToString("MM")+"/"+now.ToString("yyyy")+"')"

Regards,
Vinit Mhatre

3

@Random_Bot

"[ReceivedTime] >= '" + New DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString("MM/dd/yyyy") + "' AND [ReceivedTime] < '" + New DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).ToString("MM/dd/yyyy") + "' AND [Subject] = 'Doctor Report'"
1 Like
4

Thanks @rlgandu and @Vinit_Mhatre for your help

1 Like
5

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