What's New  


Click here to subscribe
to our weekly newsletter
Exchange Messaging Outlook
EMO back issues

To remove duplicate holidays from the Calendar folder

Outlook comes with a file named Outlook.txt (Outlook.hol in Outlook 2002) that includes lists of holidays that you can import into your personal Calendar folder using the Tools | Options | Calendar (or Calendar Options) | Add Holidays command. But it's not hard to wind up importing the same group of holidays twice. 

To get rid of the duplicates, follow these steps: 

  1. Choose View | Current View | Events to switch to the table-format Events view. All the holidays will be listed under the Recurrence: (none) group. (Outlook 2003: View | Arrange By | Current View | Events)
  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, and then drag the Created date to the view to add it to the fields displayed. 
  4. Click on the Created column header  to sort by that field.
  5. You should now see two distinct sets of holidays, each in reverse chronological order. Click on the first holiday of the set you want to delete. 
  6. Use the scroll bar to view the last holiday of that set. Hold down the Shift key as you click on the last holiday. This selects all the holidays in that set.
  7. Press Delete to remove them all from the Calendar folder. 
  8. Drag the Created column header out of the view to remove it. 

While its very easy to remove duplicate Holidays and a duplicate removal utility is not necessary, if you have duplicates of other calendar appointments, one of the tools below can remove the duplicates.

Tools
1-Click Duplicate Delete   1-click solution to remove duplicate mails, contacts or calendar items. Merges contacts automatically, has an undo function and a configurable advanced mode.
Delete Duplicated Appointments   This add-in allows you to delete duplicated appointments with just one click of a button.
Duplicate Appointments Eliminator   The Duplicate Appointments Eliminator allows you to either delete all the duplicates or move them to a folder of your choice. Comparisons of two appointments (optionally) based on subject, location, start time, end time, body, categories, recurrences, and required attendees. Works with Exchange public folders or other shared folders and you can choose to operate on a single folder or select many folders at once. Works with Microsoft Outlook 2007, Outlook 2003, Outlook 2002 and Outlook 2000. If you decide to purchase a Sperry Software utility, enter WD9BHK53 during checkout to receive a discount.
Duplicates Remover for Outlook   Delete duplicate contacts, notes, tasks, journal and calendar items in Microsoft Outlook folders and Exchange Server folders. Duplicates can be marked, copied or moved to any folder. It supports searching across the folders. Works with MS Outlook 2000/XP/2003 or later.
Outlook Duplicate Items Remover   Free tool for removing duplicate items from Outlook folders. ODIR recognizes duplicates in Contacts; Calendar; Tasks; Notes and Email folders. Using ODIR is very easy: select a folder and click the button Remove Duplicate Items. ODIR scans the selected folder for duplicates and MOVES all duplicates found to a subfolder ODIR_duplicate_items. Version 1.2
Outlook Duplicates Remover   Removes duplicate items from Calendar, Tasks, Contacts, Notes, and mail folders. Free.

More Information
  • Add Holidays Form (sample Outlook form to distribute holidays company-wide)
  • Outlook Holidays on the Wrong Date
  • Limited Holidays for Outlook 98 Calendar
  • How to Add and Delete Holidays in the Calendar  
  • OL2000: How to Delete All Outlook Calendar Items
    •
    Updated Jul 15 2008
    Copyright Slipstick Systems. All rights reserved.
    Send comments using our Feedback page

    Home | What's New | Exchange Server | Outlook | Utilities | Bookstore
    About Slipstick | Feedback | Privacy Policy | Site Map | Archived Pages | Link to Us | Advertise