I want to read my gmail calendar in Outlook 2016 (Mac and or Windows). Editing would be a plus.I use Outlook for work eMail only and don't want it to download my gmail address, but I do want to see my personal gmail calendar to avoid date collisions when adding work events.

Alternatively, can I add my Microsoft Exchange account to the Google Web Calendar?

    Not sure whether you want to achieve this via macros, but without using macros, you can try subscribing to your Google calendar in Outlook. See:

    See your Google Calendar in Outlook

    Update:

    1. Log in to your Google Calendar account.

    2. In the left column, click My calendars to expand it, click the arrow button next to the calendar that you want to add to Outlook as an Internet Calendar Subscription, and then select Settings and sharing.

    enter image description here

    1. In the opened page, scroll down to the "Integrate calendar" heading. Find the "Public address in iCal format" line.

    2. Copy the URL which is the .ics URL you need to enter in Outlook.

    3. Next steps in Outlook should be the same as it mentioned in the article I mentioned above.

    enter image description here

    • Thanks for your reply. Unfortunately this description is, like I said, completly outdated. Neither Google Calendar nore Outlook 2016 have this GUI anymore. Never the less, rereading these instructions, I realized, that in Google Calendar, one has to create first a new calendar and then go to its settings. There I found the ical address. Unfortunately, I was not able to use this address in Outlook 2016, as the option 'add web calendar' is gone.– user1323995Jan 15 at 7:21
    • 1
      Oops! Didn't realize that. However, this is still possible, just some change in the Google Calendar GUI. Since images cannot be inserted in comment, I'll edit my answer to include more details.– Steve FanJan 15 at 8:43
    • @Steve Fan: Yes, but the last line isn't cool... Who wants a public calendar?? Not a good idea at all. Want to give the bad guys a map to your house so when you go on vacation they are all set? Or, is there a way to also keep the calendar private and add it to Outlook?– DaaBossJan 15 at 14:09
    • @DaaBoss: Thanks for your heads up. Yes, there is indeed also a private ical address, called "secret address in ical format" under the same settings for the current version of google calendar. It's too bad that both companies change their GUI layout so often that even their own documentation is outdated. The only successful combination of both calendars (Google and Exchange) for me has been Apple iCal under macOS. Everything else failed ...– user1323995Jan 15 at 17:57

    Your Answer

     
    discard

    By posting your answer, you agree to the privacy policy and terms of service.

    Not the answer you're looking for? Browse other questions tagged or ask your own question.