I had a bit of an issue the other day in trying to sync up my Google Calendar with Outlook for the purpose of syncing to the iPhone.  Somehow there is the annoying “24 Hour Bug” that makes “All Day” events become 2-day events. I don’t know what the solution to that is yet, but I do know that between trying multiple sync apps in the past I have run in to the uber-annoying duplicate entries issue.

This project assumes you are using the following:

1. iPhone or another device that syncs with MS Office Outlook
2. Google’s Calendar Sync
3. Microsoft Office Outlook

Important Note: Make sure you have Google Calendar Sync set to “1 Way – Google to Outlook” in order for this to work.

In Outlook, go to “Advanced Find” (in 2003, the easy way to do this is to hit CTRL-SHIFT-F) and then look for “All Outlook Items” and hit the browse button to select ONLY THE CALENDAR – make sure “All Items” is unchecked.  Click Find Now.  When the results are displayed, click any one event, then type CTRL-A to Select All – then simply press the Delete button.  You now have a blank slate in Outlook Calendar.

Note: I did this without changing my GCAl Sync settings, so I lost everything.  I should have used my iPhone to manually rebuild everything, but I didn’t.  I tried to sync.  Outlook took priority and therefore wiped my iPhone cal too.  Pretty sad.  Trying to rebuild a calendar is counter-intuitive.  You put everything on the Cal so you didn’t have to remember yourself.