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-
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
Diane Poremsky Junk Mail Filtering in Outlook New Slipstick.com Articles 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
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
B See "Change View" Drop Down as a List? Using Outlook 1
B 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 Calendar Printing Assistant 1
N Outlook 2013 Folder View Using Outlook 8
J Outlook 2016 shows Meeting Organizer in Calendar View Using Outlook 5

Similar threads

Top