SQL Task Filter

P

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
 
M

Michael Bauer [MVP - Outlook]

Try this:

(%next7days("urn:schemas:httpmail:reply-by")% OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" = 'Agendas' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Projects and Tasks without a Start date and/or finish date:MS Project 2007 1
task doesn't appear in "Today" list 0
Incorrect dates when copying from Excel 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Complex Count Query 0
Changing Baseline dates due to snow days 0

Top