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.