Filtering a view based on a custom field

Status
Not open for further replies.

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-
 
It's because its a formula field. You can use VBA to make the calculations, which will be sortable, groupable, and filterable. See http://www.slipstick.com/outlook/email/sort-messages-sender-domain/

I created a custom field using the first macro on the page - replaced two lines with the following:

Code:
         strDomain = (objMail.ReceivedTime - objMail.SentOn) *  1440
         Set objProp = objMail.UserProperties.Add("DelayTime", olInteger, True)
Those lines will work in any of the other macros on the page.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D What is the To-Do List VIEW" Filtering On? Using Outlook 2
O After filtering, how to display all events on that day? Using Outlook 4
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
Diane Poremsky Junk Mail Filtering in Outlook Using Outlook 0
oliv- .RESTRICT returning birthdays regardless of the filtering date Outlook VBA and Custom Forms 8
J Outlook 2013 Want to file a note after filtering with search current mailbox Using Outlook 3
S Filtering based on mailing list field Using Outlook 1
G filtering email with missing TLD to Junk Outlook VBA and Custom Forms 1
cimbian Filtering exclusive imported contacts Using Outlook 3
Commodore Junk Mail filtering and IMAP Using Outlook 3
U Filtering or Rules against "Tracked Conversations" Using Outlook 6
C starting Outlook 2003 sp3 sets Junk Email setting to 'No automatic filtering' Using Outlook 3
S Inbound email filtering beyond Rules Using Outlook 7
R Filtering messages requesting Read Receipts Using Outlook 1
C Advice on custom filtering Outlook VBA and Custom Forms 2
K Protected View - Files fail, no banner Using Outlook 4
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
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
D Unable to view older emails in desktop app Using Outlook 0
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
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
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
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
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

Similar threads

Back
Top