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:blush:ffice:blush:ffice#Keywords" = 'Agendas' OR
"urn:schemas-microsoft-com:blush:ffice:blush: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

How to create the customized Outlook SQL DASL for selected days? 2
Save Task Filters 1
Exclude categories from group by display in tasks 2
Web Access - Looking for Alternative Way to Categorize Tasks 2
How can I automatically assign a category to a task? 2
Outlook Today should allow selection of tasks to display by catego 4
Filter in Outlook 2007 to-do bar 1
Outlook 2003 - set a task filter to show due in seven days or earl 4

Top