Microsoft Outlook comes with a file named Outlook.hol (Outlook.txt in Outlook 2000 and older) 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. This makes it easy to add holidays and many users wind up importing the same group of holidays twice.
You can remove the duplicates one of two ways: delete all events in the Holiday category then re-add the holidays you want added or use the Created date field to sort by date added an delete the duplicates, which added at the same time.
You can use the Sort by Created date method to remove any duplicated calendar items.
Delete the Holiday category
In Outlook 2007 and Outlook 2003: switch to the By Category view.
In Outlook 2010 and 2013: switch to a List view then arrange by Category.
Select the Holiday category then press Delete.
Go to Options, Calendar and click Add Holidays. Select the Locations you want to install and complete the wizard.
Sort by Created date
In Outlook 2010 and Outlook 2013:
- Switch to the View ribbon and select Change View, List
- Click View Settings then Columns
- Select Created and click Add -> to add it to the view
- Click OK to return to Outlook
- Sort by the Created date field
- The holidays that are imported together will have the same Created date
- Select the first event and hold Shift as you select the last
- Press Delete
To remove the duplicates from Outlook 2007 and older
To use the Created date method to delete duplicated appointments in Outlook 2007 and older, follow the instructions below.
- 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)
- Right-click any column heading, then choose Field Chooser.
- 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.
- Click on the Created column header to sort by that field.
- 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.
- 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.
- Press Delete to remove them all from the Calendar folder.
- 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 in the Spotlight
Outlook Duplicate Killer is add-in for Microsoft Outlook. Find, merge and remove Outlook duplicates. Compare, assign category, flag and move duplicates to selected folders. Find and remove duplicate contacts, emails, calendar events, tasks and notes automatically. Merge Outlook contacts and other items. Manage duplicates in any Microsoft Outlook folder, including Microsoft Exchange and Public folders. Preview duplicate search results prior to processing. Use with Microsoft Outlook 2016, 2013, 2010, 2007, 2003, 2002
Deduper does exactly as the name suggests, it searches and removes all duplicates - including appointments, contacts, notes, tasks or emails.
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.
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. Supports all versions of Outlook, including Outlook 2007/2010. Version 2.6
1-click solution to remove duplicate mails, contacts or calendar items. Merges contacts automatically, has an undo function and a configurable advanced mode. Version 3.03 Now supports Outlook 2010 (both 32 and 64 bit).
Duplicate Remover will find, merge and remove duplicates in 3 steps using simple search wizard. Search duplicate items and merge Outlook duplicates automatically. We create a list of similar contacts for you to review, this way you will not delete sensitive contacts. Remove Outlook Inbox duplicates, duplicate Contacts and Calendar events and Junk contacts. Quickly clean up all your contacts. Automated inbox scanning and duplicates removal.
Accurate Outlook Duplicate Remover (AODR) can find and remove all duplicate Outlook items automatically. It quickly removes duplicates from Contacts, Calendar, Tasks, Notes and Email folders in one click. You can select any folder for duplicate Removing. It helps you to use your Outlook much more efficiently. Free for up to 200 contacts.
Delete Duplicates for Outlook deletes duplicate e-mails. Detect and remove duplicate messages, contacts, calendar items, tasks, journal entries and notes. Compare messages by content (Standard), by part of the content (Special) or by unique message-id's (Light). Compare attachments and/or embedded files, by name and/or by content. Compare duplicates across several mailboxes or in within the boundaries of individual mailboxes. Use Regular Expressions. Works with all Outlook versions, inc. Outlook 2010/2013 32 or 64-bit.
Kernel for Outlook Duplicates Remover tool is specifically programmed to remove duplicate items of MS Outlook permanently. The tool easily locates all duplicate Outlook items and provides option to either manage them or remove them permanently. The tool supports removal of duplicate items for all MS Outlook versions. Its free trial version can remove 10 items from each folder and expires after 30 days of download.
NoMoreDupes detects and removes all duplicated Outlook items both in an Outlook pst file, a public folder or in an Exchange account. It shows the found duplicates in a preview for the user to decide which duplicates to remove. You can move the duplicated Outlook items to your "Deleted Items" or to any other folder you specify. NoMoreDupes uses a special algorithm to detect the Outlook duplicates. This Outlook-Add-In works with all versions of Outlook, including Outlook 2010/2013 64bit.
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
ReliefJet Essentials for Outlook is a straightforward tool that consists of a large set of useful and easy-to-use tools for every Microsoft Outlook user. The product seamlessly integrates with Outlook and includes Outlook add-in, standalone and Windows command line applications. Utilities can be run in manual and automatic modes as well as on a scheduled basis. This major update includes new utilities and features as well as performance and reliability enhancements. Imports email messages from MBOX files into Outlook/Exchange folders with Internet headers. Converts MBOX files to MSG for EML.
Clean up your Outlook mailbox from unwanted and duplicate emails with Outlook duplicate remover tool. This software works as an Add-Ins in Outlook and removes duplicates as per different time span and scan criteria. Customized operations like Mark as Expired or Flag, Delete Permanently, Copy to folder and more are also a notable feature of this software.
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 (MSKB)
OL2000: How to Delete All Outlook Calendar Items (MSKB)
Microsoft Outlook’s missing holidays (Outlook-tips)