#Delete duplicates in outlook how to#
#Delete duplicates in outlook install#
#Delete duplicates in outlook manual#
#Delete duplicates in outlook software#

For details on how to configure impersonation for Exchange On-Premises or Office 365, see this blog post.

#Delete duplicates in outlook install#

For an example of how to install from NuGet, see this article for MSAL follow the same process but with the package titled ‘’.Īlso take notice that since you’ll be processing user mailboxes, you’ll need to have full mailbox access or impersonation permissions when using Basic Authentication the latter is preferred. You can install these packages from NuGet, or place their DLL’s in the same folder as the script. Using the Remove-DuplicateItems.p1 script requires Exchange Web Services (EWS) Managed API and for OAuth authentication the Microsoft Authentication Library (MSAL) libraries. Wouldn’t it be nice if you’d have a PowerShell script you can conveniently run from any workstation (or server) with PowerShell installed, removing those duplicate items from a user’s mailbox remotely? If the answer is yes, the Remove-DuplicateItems.ps1 script may be something for you. When you’re an Apple shop you’ll require different tools, unless you’re running a Windows desktop somewhere (I’ll just pretend I didn’t hear you saying ‘Why don’t you install the tool on the Exchange server’).

#Delete duplicates in outlook software#

When you finally have selected a tool, in most cases they require installation of a piece of software and someone to perform the removal process using the tool or Outlook with add-in. Not all this software is free (some even require payment per duplicate removal of appointments, contacts or e-mail) and some might not even work (MAPI-based tools may not work against Exchange 2013).

When continuing your search, you’ll find lots (I mean lots!) of tools and Outlook add-ins, like Vaita’s DIR or MAPILab’s Duplicate Remover.

#Delete duplicates in outlook manual#

This article describes a manual procedure to remove duplicates entries from your calendar, contacts, inbox or other folders. When looking for a solution, you’ll probably encounter MSKB299349, “How to remove duplicate imported items in Outlook”. Accidental import from – for example – a PST file to a mailbox can lead to duplicate entries. In the past, I’ve seen this happening with Nokia PC Suite and Google Apps Sync for example

Entries from the mailbox are treated as new entries and as a consequence are added to the mailbox when synchronizing information back to the mailbox, creating duplicates. Duplicate items can be caused by many things, but most common are: Open the VBA Editor by pressing Alt+F11 on your keyboard.For those involved with Exchange migration projects or managing Exchange environments, at some point you probably have experienced the situation where people ended up with duplicate items in their mailbox. The macros on this page should be placed in a module. In Outlook 2007 and older, look at Tools, Macro Security.Īfter you test the macro and see that it works, you can either leave macro security set to low or sign the macro. To check your macro security in Outlook 2010 and newer, go to File, Options, Trust Center and open Trust Center Settings, and change the Macro Settings. You can sign the macro when it is finished and change the macro security to notify. You could choose the option Notification for all macros, then accept it each time you restart Outlook, however, because it's somewhat hard to sneak macros into Outlook (unlike in Word and Excel), allowing all macros is safe, especially during the testing phase. The macros will not work with the top two options that disable all macros or unsigned macros. If objDictionary.Exists(strKey) = True Thenįirst: You need to have macro security set to the lowest setting, Enable all macros during testing. StrKey = objItem.Subject & ',' & objItem.Body & ',' & objItem.SentOn If InStr(1, objItem.MessageClass) 'IPM.Schedule' Then Set objDupFolder = ('Duplicates')įor i = To 1 Step -1 Set objDictionary = CreateObject('scripting.dictionary') After reviewing the duplicates, delete the folder. The macro will create a subfolder named Duplicates and move the duplicate messages to it. To use, select a folder that needs checked for duplicates and run the macro. See Duplicate Remover Tools for third party utilties. If you have a lot of messages in the folder, expect it to take some time to run.