#1
|
|||
|
|||
Macro search query for past 4 weeks?
Hi there I've set up a macro in an attempt to have a Unified inbox view across my 2 work email accounts in Outlook O365. The macro is: Sub UnifiedInbox() Dim myOlApp As New Outlook.Application txtSearch = "folder:Inbox received: (this month)" myOlApp.ActiveExplorer.Search txtSearch, olSearchScopeAllFolders Set myOlApp = Nothing End Sub My question is this - is there a query to return search results for the 'last 4 weeks'? Or past 30 days? Or equivalent? I can only see this week, last week, this month, last month, this year, last year as the standard variables. These are pretty restrictive and a bit shortsighted - for example if I use 'this month' at the start of the month (like today for example) I get next to no results. Any help would be greatly appreciated. Cheers Ben |
#2
|
|||
|
|||
Hi - can anyone help me with my query please?
Cheers Ben |
#3
|
|||
|
|||
Rather than use VBA — or as an aid to zero in on the appropriate VBA instruction — try the standard Outlook search filter "received:"
Specify relative dates such as today, tomorrow, yesterday, or multi-word relative dates such as this week, next month, last week, past month, coming year. But you can also enter expressions like this in the search box: received>=10/1/2020 AND received<=10/5/2020 Not sure this translates into VBA, although my guess is that it does. |
#4
|
|||
|
|||
Maybe something like this?
Sub UnifiedInbox() Dim myOlApp As New Outlook.Application Z = Date - 30 txtSearch = "received:>=" & Z myOlApp.ActiveExplorer.Search txtSearch, olSearchScopeAllFolders Set myOlApp = Nothing End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2010 Not syncing past two weeks out | jacijarman | Outlook | 0 | 01-25-2016 10:43 AM |
Outlook search query: e-mails sent to domains other than a specified set | elliotshelton | Outlook | 0 | 11-21-2015 01:53 PM |
Microsoft Access search macro/query | algebrapro18 | Misc | 1 | 06-18-2014 04:10 PM |
Odd search and replace query | Rabski | Word | 1 | 11-13-2012 02:25 PM |
Filtering past or future events in DRW query criteria | jvieille | Misc | 1 | 02-11-2006 06:26 AM |