Group Calendar in Public Folders (2003)

Topic

New Reply

Hi, I am attempting to create a “TimeOff Calendar” for a 60+ company. This company is in the process of switching to Outlook 2003 with Exchange Server and the IT person doesn’t really know Outlook/Exchange. However, she gave me permission to create public folders. I have created a New Folder in Public Folders with “Calendar Items”. I am the owner; everyone else has permission to add items and to edit their own (they cannot delete anything).

My simple question is how to add US Holidays to this Public Folder Calendar?

Thanks,
–cat

Reply | Quote

Replies

According to Microsoft Outlook Holiday Issues[indent]

---

You cannot add holidays directly to a public folder. Instead, add them to your default Calendar folder either by using the Add Holidays method or by importing from a file with the Import and Export Wizard. Then, move or copy the new holiday items to your public folder.

---

[/indent]See the link for details.

Reply | Quote

Thanks, Hans.

After reading the link and fumbling around quite a bit, I still cannot figure out how to copy the holidays. I found the Outlook.hol file and modified it to contain only US holidays and made it an Excel file. However, I could not Import it. When the Import wizard asked for me to Select a Destination, the Public Folders were not there to select.

I’m sorry for being so dense …

–cat

Reply | Quote

As the Slipstick article mentions, you cannot import holidays directly into a public folder. You will have to import them into your default Outlook calendar. Then do the following (courtesy of To remove duplicate holidays from the Calendar folder in Microsoft Outlook on the same site):

1. Select View | Arrange By | Current View | Events. All the holidays will be listed under the Recurrence: (none) group.
2. Right-click any column heading, then choose Field Chooser.
3. In the Field Chooser, switch from the Frequently-used fields list to Date/Time fields.
4. Drag the Created date to the view to add it to the fields displayed.
5. Click on the Created column header to sort by that field.
6. You should now see two distinct sets of holidays, each in reverse chronological order.
7. Click on the first holiday of the set created today.
8. Use the scroll bar to view the last holiday of that set. Hold down the Shift key as you click on the last holiday created today. This selects all the holidays in that set.
9. Cut the selected holidays, then paste them into the public calendar folder.
10. Switch back to your calendar.
11. Drag the Created column header out of the view to remove it.
12. Restore the original calendar view.

HTH

Reply | Quote

Thank you very much. I learned a lot about customizing the Calendar from the steps you provided. And, I was able to copy the holidays to the public calendar!

You are very kind and helpful,
–cat

Reply | Quote