Syncing Google calendars with Outlook 2007

I was trying to get Outlook 2007 to sync with my Google calendars. For those who don’t know, doing this takes a few quick steps:

  1. Go to your Google Calendar page.
  2. Under the My Calendars section on the left, click the down-arrow next to the calendar you want to sync, and select Calendar Settings.
  3. At the bottom, click the ICAL button in the Private Address line.
  4. Copy the URL provided to the clipboard.
  5. Open Outlook 2007 and go to Tools / Account Settings.
  6. Click the Internet Calendars tab, then click New.
  7. Paste the URL you copied in step 4 into the box and click Add.
  8. Finish as prompted.

Easy enough, and I was able to sync my personal Google calendar (linked with my bdemarzo@gmail.com account) this way. However, when I tried my hosted Google calendar (linked with bdemarzo@computersims.com), step 7 would fail; Outlook said it wasn’t a recognized calendar format.

The problem is that Outlook apparently has an issue with calendars hosted via HTTPS, and may have an issue with the email address in the URL to your calendar.

Consider the private URL to my personal Google calendar (hosted with my plain vanilla GMail account).

GMail Calendar private address window

Now, consider the private URL to my hosted domain Google calendar (i.e. my computersims.com account).

GMail Hosted Calendar private address window

When pasting the calendar address for a hosted domain Google calendar account into Outlook, you need to do the following:

  • Change the protocol from HTTPS to HTTP.
  • Replace the %40 symbol in the email address to the at symbol @.

As a result, this…

https://www.google.com/calendar/ical/bdemarzo%40gmail.com/private-0123456789ABCDEF0123456789ABCDEF/basic.ics

…becomes this:

http://www.google.com/calendar/ical/bdemarzo@gmail.com/private-0123456789ABCDEF0123456789ABCDEF/basic.ics

Note the emphasized sections are the only ones changed. Do this, and Outlook 2007 reads your hosted Google calendar fine!

Of course, this is all a one-way sync — you can’t add things to your Google calendar from Outlook — but it’s better than nothing at all.

Bookmark and Share

Popularity: 31% [?]

Related Posts

The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.

-- Ninety-Ninety Rule

Comments 3

  1. Borik wrote:

    Or you can use iCal Link, without punishing your self…

    Posted 13 Feb 2008 at 5:39 pm
  2. Frank Valletutti wrote:

    http://www.busymac.com/

    Answer to all your Google Cal / iCal syncing problems.

    Posted 16 Feb 2008 at 12:10 pm
  3. Dennis wrote:

    Thanks for the tips. When I tried to get hosted domain ical to work I only changed %40 to @ but I didn’t try changing it to http.

    Posted 02 Dec 2008 at 5:37 pm

Post a Comment

Your email is never published nor shared. Required fields are marked *