Get Outlook mail message Filter

Try these filters:

"[Received] >= '" + DateTime.Today.ToString("d") + " 00:00AM'"

or

"[ReceivedTime] >= '" + DateTime.Today.ToString("d") + " 00:00AM'"

or

"[Received] >= '08/08/2022' AND [Received] <= '08/10/2022' "

Reference: Get Outlook Mail Messages


If you want for three days ago:

"[Received] >= '"+now.AddDays(-3).Date.ToShortDateString+"' AND [Received] <= '"+now().Date.ToShortDateString+"'"

sFilter = "[Received] > '" & Format("8/10/2022 3:30pm", "ddddd h:nn AMPM") & "'"

Reference: Items.Find method (Outlook) | Microsoft Learn

Check this solution also: Get Outlook Messages Filter for Specific Date - #12 by prasanthpulipati

Let us know if these helped.

1 Like