Thread: Button Filter
View Single Post
  #2  
Old January 10th 07, 05:44 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Button Filter



For getting the query syntax you can build the query by customizing the
view, create the filter with the wizard and then see the SQL page.

E.g., this one is for all items received at or after 1.1.2000:

"urn:schemas:httpmail:datereceived" = '01.01.2000 00:00'

You can modify the current view by the
Explorer.CurrentFolder.CurrentView.Xml property. Print out some examples to
see how the Xml string must look like.

For your requirement I think you'd have to build the query new each day. Use
the function DateAdd("d", -166, Date) and insert the returned value into the
SQL query.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Tue, 9 Jan 2007 07:46:01 -0800 schrieb Scott:

Hi all - I would like to know how I could filter my mail by a specific age

by
clicking a button on the Outlook 2003 tool bar. I have a filtered view

with
the default 7 days that Outlook provides, but I would like to modify this

to
166 days and have it display all messages in my inbox (again, by click a
button). Any suggestions on how I can tackle this?

Ads