Saturday, October 16, 2010

How to eliminate duplicate Outlook tasks when you have both gmail IMAP and Exchange accounts

Gmail IMAP in Microsoft Outlook 2007 is great, except for the fact that starred or flagged emails are duplicated two or three times in the task list and to-do list. If you only use gmail the solution is to add a filter criteria such as "In Folder" is (exactly) "All Mail" but this hides any flagged Exchange emails and Outlook tasks.

The solution is to create a custom SQL filter with the compund logic that can't be achieved using the "Advanced" filter dialog. The logic that works for me is "Email Account is empty OR (Email Account contains "gmail" AND In Folder is (exactly) "All Mail"). Here's how you do it:

  1. Right click on the a blank part of the task list or to-do list and click Filter.
  2. Click the SQL tab and check "Edit these criteria directly..."
  3. Open an new text file with Notepad
  4. Copy the contents of the SQL criteria box and paste into Notepad. Save this file as "original_task_filter.txt" so you can restore the default filter by pasting it back if this custom filter doesn't work well for you.
  5. Overwrite the existing criteria completely with the text below:
    ("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040" IS NULL AND "http://schemas.microsoft.com/mapi/proptag/0x10910040" IS NULL AND ("http://schemas.microsoft.com/mapi/id/{00062008-0000-0000-C000-000000000046}/8580001f" IS NULL OR ("http://schemas.microsoft.com/mapi/id/{00062008-0000-0000-C000-000000000046}/8580001f" LIKE '%gmail%' AND "http://schemas.microsoft.com/mapi/proptag/0x0e05001f" = 'All Mail')))
  6. Click OK.
  7. Repeat these steps for any other task lists or to-do lists that show duplicate gmail tasks. You should only have to back the original criteria up once.

2 comments:

  1. just what i needed. thanks!!

    ReplyDelete
  2. Works perfectly. Thank you!!

    ReplyDelete