SQL Task Filter
 

Good morning --

Using Outlook 2003 on a corporate server, I organize all my tasks into
categories with start and finish dates, except for those in two categories:
Agendas & Projects. I'd like to filter for the following:

* Tasks in any category with a due date within 7 days
- plus -
* All tasks in the Agendas & Projects regardless of due date

I haven't been able to figure this out without an SQL query. Can someone
help me with this?

TIA

SQL Task Filter
 

Try this:

(%next7days("urn:schemas:httpmail:reply-by")% OR
"urn:schemas-microsoft-com:office:office#Keywords" = 'Agendas' OR
"urn:schemas-microsoft-com:office:office#Keywords" = 'Projects')

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Fri, 6 Mar 2009 11:11:01 -0800 schrieb pdberger:

Good morning --

Using Outlook 2003 on a corporate server, I organize all my tasks into
categories with start and finish dates, except for those in two
categories:
Agendas & Projects. I'd like to filter for the following:

* Tasks in any category with a due date within 7 days
- plus -
* All tasks in the Agendas & Projects regardless of due date

I haven't been able to figure this out without an SQL query. Can someone
help me with this?

TIA