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?