Search for incoming e-mails for a specified time range

Tomohawk

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
I need to create a report of the number of incoming e-mails for a specific date/time range and by category. Each e-mail is categorized, but would also need to report those with blank category, so best to report by all categories. The report would take the form of a list of those e-mails, ordered by category. I can select the range for each category and get the count that way.

Is it possible to create a search, which prompts for start date and time and end date and time and that can be saved and reused for this purpose.

Thanks

T
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You can do instant search, which is set up using a macro - or you can use a view with the fields visible that you need and copy & paste into Excel and filter there.

This macro has some examples - you'll replace the search string with the one you need and use input boxes to get the dates you want to use
For example, for received:>11/1/2019 <11/11/2019 category:="Anniversary"

strStart = InputBox("Enter Start date", "Enter date in mm/dd/yy format")
strEnd = InputBox("Enter End date", "Enter date in mm/dd/yy format")
strCategory = InputBox("Enter Category", "Enter category name")

txtSearch = " received:>" & strStart & " <" & strEnd & "category:=" & chr(34) & strCategory & chr(34)

 
Thread starter Similar threads Forum Replies Date
D Custom Search Folders not refreshing/updating automatically Using Outlook 0
L New Location for the Search Bar Using Outlook 7
T How can you include Junk Email in Search Results like you can include Deleted Items? Using Outlook 3
J Outlook 2016 After a search in all mailboxes, where is each message that was found? Using Outlook 6
King Mustard Sort search groups by amount of items? Using Outlook 1
V Outlook 2016 will not move emails in search results Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
M Outlook macro to automate search and forward process Outlook VBA and Custom Forms 6
J Message search and edit, another way? Outlook VBA and Custom Forms 4
S Create A Search Folder That Looks For Message Class? Outlook VBA and Custom Forms 0
R Outlook for Mac - Advanced Search and Tracking Sent Emails Using Outlook 0
R Search/Jump to a folder by typing its name Outlook VBA and Custom Forms 1
M Sent mail not showing in Sent Items folder; but they can be found with Search Using Outlook 3
A Outlook 2019 having issues with 'people search' and not making suggestions in email To: etc Using Outlook 12
W Search Incomplete Outlook 2016 Using Outlook 5
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
A Using or not using apostrophes in search terms has this changed? Using Outlook 0
R outlook address book search broken Using Outlook 2
K Outlook.com is not showing, or finding via search, all my Contacts (People) Using Outlook 0
W Create Search Folder excluding Specific Email Addresses Using Outlook 5
R What's supposed to appear when just clicking into the search field? Using Outlook 7
A Outlook macro to create search folder with mail categories as criteria Outlook VBA and Custom Forms 3
M possible to search Outlook for multiple email addresses at once? Using Outlook 1
B Instant search with special characters Using Outlook 1
A Search folder refresh Outlook VBA and Custom Forms 3
B Advanced Search in MS Outlook by VBA and SQL Outlook VBA and Custom Forms 2
M email search not working Using Outlook 1
F Search folder for tasks in all task folders Using Outlook 1
W Outlook 2016 search problem persists after applying all known solutions Using Outlook 12
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
B Search: Cannot find which Folder Contains a Message Using Outlook 3
M how to speed up search of shared contacts Using Outlook 0
B When I add more search strings to RULES, it is not processing them Using Outlook 3
C Search with Google Macro? Outlook VBA and Custom Forms 4
E Search for folder by key in subject then move new message to related folder Outlook VBA and Custom Forms 1
E Outlook 2016 Inbox search bug Using Outlook 1
C Filter/Search emails sent to internal Exchange address only Using Outlook 2
M VBA macro for Inbox's attachments search Outlook VBA and Custom Forms 0
P Outlook search is not working at all for Calendar & Tasks Using Outlook 7
M Recent Update Did not Fix Search Problems Using Outlook 7
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
M new search just... sucks Using Outlook 4
B Search function in Office 365 has stopped working Using Outlook 3
J Marco in search of text in subject line Using Outlook 8
T Delete Emails from search results Outlook VBA and Custom Forms 1
P Can't search Archive'd Tasks Using Outlook 0
S VBA Code to move mail items from search folder to inbox subfolder Outlook VBA and Custom Forms 4
J Search by catagory Using Outlook 4
skyfox VBA to search email subject field for a certain string Outlook VBA and Custom Forms 3
Similar threads


















































Top