Randy Redekopp
New Member
- Outlook version
- Outlook 2016 32 bit
- Email Account
- Office 365 Exchange
We use Outlook 2013 (and 2010) connected to Exchange accounts on Office 365 enterprise plan.
I have create a custom field that shows the delay time between when an email was sent (or at least when it is shows as being sent), and when it was received. I created it in the user’s inbox and also created it in their deleted items folder.
Name: Delay Min
Formula: int(([Received]-[Sent])*1440)
This part works great and I have created a search folder which includes both the Inbox and Deleted Items folders (without subs). I can see and choose my custom field just fine on the view screen.
I created a new view for that search folder and filtered it based on email received in the last 7 days. I want to further filter that list down to only show email where the Delay is > 1 minute. BUT… I cannot reference my custom field for the filter screen. The “User Defined fields in <folder>” is blank for filtering, grouping, and for query builder. I am familiar with SQL so thought I might be able to use that but don’t have a data dictionary or any examples to get started there.
Is what I am trying to do possible? If so, how would you suggest I tackle it?
Thanks!
-Randy-
I have create a custom field that shows the delay time between when an email was sent (or at least when it is shows as being sent), and when it was received. I created it in the user’s inbox and also created it in their deleted items folder.
Name: Delay Min
Formula: int(([Received]-[Sent])*1440)
This part works great and I have created a search folder which includes both the Inbox and Deleted Items folders (without subs). I can see and choose my custom field just fine on the view screen.
I created a new view for that search folder and filtered it based on email received in the last 7 days. I want to further filter that list down to only show email where the Delay is > 1 minute. BUT… I cannot reference my custom field for the filter screen. The “User Defined fields in <folder>” is blank for filtering, grouping, and for query builder. I am familiar with SQL so thought I might be able to use that but don’t have a data dictionary or any examples to get started there.
Is what I am trying to do possible? If so, how would you suggest I tackle it?
Thanks!
-Randy-