Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   View emails sent by time range excl weekends (http://www.outlookbanter.com/outlook-vba/101133-view-emails-sent-time-range.html)

PMR March 19th 10 04:12 PM

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

Salad March 20th 10 02:39 AM

View emails sent by time range excl weekends
 
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.




All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com