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.
Thread starter Similar threads 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
A Exchange 2010 SP1 Edge Server ( Content Filtering ) Exchange Server Administration 0
V exe file filtering in exchange Exchange Server Administration 2
P Exchange 2010 - Enable Spam filtering on Hub Transport Server Exchange Server Administration 3
T Distribution Lists, Selecting members, filtering members out of the selection process (not one by one) Using Outlook 2
M i can't Disable Junk E-Mail filtering on a specific user mailbox Exchange Server Administration 1
E Re: Get-CASMailbox not returning same result with Server side filtering and Client side filtering? Exchange Server Administration 2
C Sender Filtering action: Stamp with blocked sender not working Exchange Server Administration 3
Z How to enable Content Filtering for Inbound and Outbound Emails on Exchange 2007? Exchange Server Administration 4
C Advice on custom filtering Outlook VBA and Custom Forms 2
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
Similar threads


















































Top