How to prevent duplicated items in Outlook 2007’s To-Do Bar when using Google IMAP account
The How-to Geek gave a way to prevent duplicated items in Outlook 2007’s TO-DO bar when using Google IMAP account.
He used the advanced filter to filter all the items outside the inbox directory. But actually all the criteria in the advanced filter dialog are combined with “AND” operator, so other regular outlook tasks will not display as they are in the “Task” directory.
If you’d like to display the flagged items from Google IMAP folder together with regular outlook tasks, I suggest you should use the SQL filter as below:
In the SQL statement, we could use the “OR” operator to connect multiple criteria. Below is the SQL statement I used, and hope it helps you.
(”http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040″ IS NULL AND “http://schemas.microsoft.com/mapi/proptag/0×10910040″ IS NULL AND (”http://schemas.microsoft.com/mapi/proptag/0×0e05001f” LIKE ‘%Task%’ OR “http://schemas.microsoft.com/mapi/proptag/0×0e05001f” LIKE ‘%Inbox%’ OR “http://schemas.microsoft.com/mapi/proptag/0×0e05001f” LIKE ‘%SNEPC%’ ))
