View emails sent by time range excl weekends

Status
Not open for further replies.
P

pmr

Want to create a query to view email by sent time range e.g. 9-5 excl weekends
 
S

Salad

pmr wrote:


> Want to create a query to view email by sent time range e.g. 9-5 excl weekends

Not an Outlook expert but you could set a filter.

Mon(1)-Fri(5) if vbMonday used.

? weekday(now(),vbMonday) <= 5

True

Look at the Restrict method in help for filtering.
 
Status
Not open for further replies.
< Template or Form? | Automatically modifying an email >
Similar threads
Thread starter Title Forum Replies Date
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
D Unable to view older emails in desktop app Using Outlook 0
D cannot view emails in View pane (in the right pane), I only see one line or nothing Using Outlook 21
B Outlook 2016 Unable to view images or logos on the outlook 2016 emails the same html code works well when i use outlook 2010 Using Outlook 0
A How To Get Body of All Emails to view in Blue Using Outlook 1
A How to get body of all emails in outlook 2016 to view in blue color Using Outlook 1
avant-guvnor Unable to view certain emails in Outlook 2016 Using Outlook 16
K Protected View - Files fail, no banner Using Outlook 4
T Problem when requesting to view an email in a browser Using Outlook 0
S Inconsistent view of To-Do List Using Outlook 0
C View doesn't refresh (fields or formatting) Using Outlook 1
Commodore MHT files (from "View in browser") Using Outlook 7
J How to create a drop down user defined field that will appear on an inbox view Outlook VBA and Custom Forms 8
O In Agenda-view - How to copy an existing item months ahead or back? Using Outlook 0
J Split reading view with history Using Outlook 2
P Calendar Day View only shows 1 all day event Using Outlook 0
C Can't Locate an Unread Message in my Outlook view pane Using Outlook 0
D Autosort macro for items in a view Outlook VBA and Custom Forms 2
D Anyone tell me where custom view settings are stored? Outlook VBA and Custom Forms 9
P Changing the font that the task view shows Using Outlook 5
E Outlook view grouping keeps changing Using Outlook 3
K UDF with formula not showing on Calendar custom view. Outlook VBA and Custom Forms 0
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
J Weekend View in Calendar Using Outlook 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
Z See "Change View" Drop Down as a List? Using Outlook 1
Z How to show concatenated categories in list task view? Using Outlook 2
K Accentuating today in Outlook calendar month view Using Outlook 2
W Outlook Calendar does not save view any longer! Using Outlook 3
T How can we view Blocked email addresses Using Outlook 6
N Private check box in table view Using Outlook 0
E Mail sorting view issue Using Outlook 1
P How can I change my calendar view back Using Outlook 3
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
G Calendar View in Outlook Office 365 - Doesn't show enough hours, and the 30/60 min choice isn't the solution Using Outlook 4
O How to apply view settings on all accounts and folders Using Outlook 7
D.Moore Folder view settings by VBA macro Outlook VBA and Custom Forms 57
A Add to Outlook Contacts from email - default view Outlook VBA and Custom Forms 1
N Column view fonts Using Outlook 4
J Contact Business card view Using Outlook 11
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
U HTML Task Alternate Home Page View Control Using Outlook 3
R Quick Access view in File Explorer when saving attachments Using Outlook 0
J Outlook 2016 - Tasks View Settings Missing Using Outlook 1
copperberry How to view all tasks across task folders Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
A Day view - print appointment details Using Outlook 1
N Outlook 2013 Folder View Using Outlook 8
J Outlook 2016 shows Meeting Organizer in Calendar View Using Outlook 5

Similar threads

Top