PDA

View Full Version : Create a new View for Tasks on Outlook 07



Chutchinson
06-24-2008, 08:03 AM
Help!

I am a newbie in the GTD forum, but don't know where else to ask. I need to create a 'next 14 days' view (in Tasks) for my sales people in Outlook 2007.

I have the SQL to do it in the earlier versions, but get an error message when I try to use it in the 2007. Does anyone have any ideas?

Thanks!
Here is what I use in the earlier versions:
(
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/811c000b" = 0)

AND

(NOT("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040" IS NULL))

AND

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040" <= today(1209600))
)

clango
06-25-2008, 12:08 PM
What kind of salesman is one who cannot have it's own goal?

And please ...from salesman to salesman...you have to dream your goal!

With friendship and respect

Claudio

Chutchinson
06-26-2008, 05:34 AM
I don't need to change salesmen (maybe CEO's though). We have implemented a new program that causes several reminders to be sent for each of their contacts(like going out 4 months).

This causes their task lists to be extensive. In an effort to help them manage th volume better, our CEO wants them to view their list for a 2-week period, but there is no function set up in Outlook to do this. Therefore, I need to create a custom view. Hence the SQL code.

Thanks for the thought though.

Cindy:cool:

KellySY
06-27-2008, 04:21 AM
I'm no use with SQL, but will this filter work for you:


Due Date on or before two weeks

Chutchinson
06-30-2008, 04:41 AM
Thanks! I didn't know that was an option in 2007. I only have the older version on my computer so I don't have much experience with 2007.

Have a great holiday!!!