Forum

  • If you are new to these Forums, please take a moment to register using the fields above.

Announcement

Announcement Module
Collapse
No announcement yet.

Create a new View for Tasks on Outlook 07

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Create a new View for Tasks on Outlook 07

    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))
    )

  • #2
    Change the salesmen!

    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

    Comment


    • #3
      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

      Comment


      • #4
        I'm no use with SQL, but will this filter work for you:
        Due Date on or before two weeks

        Comment


        • #5
          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!!!

          Comment

          Working...
          X