Instead, you should eliminate them as soon as possible. Thus, you shouldn’t disregard any small errors. However, it is the tiny error that triggers serious Outlook crashes, which will jeopardize the Outlook file. Many users are inclined to ignore the random errors. Perhaps you have encountered various Outlook issues. Ultimately, you may receive a message prompting the count of removed duplicates, like the screenshot below:ĭespite loaded with quantities of excellent functions, Outlook is still susceptible to errors and corruption.Also, in the meantime, duplicates will be auto removed. After that, Outlook will begin to move all the items from the source folder to the target one.The first one is the source one, and the second one is the target one. Then you need to select the two folders to be merged.Next press F5 key button to trigger this macro.Firstly, back to the new module window.Later you need to check out your Outlook macro settings, ensuring macro is enabled.MsgBox x & ' duplicates removed when merging!', vbInformation + vbOKOnly 'Prompt you of the count of removed duplicates If objDictionary.Exists(strKey) = True Then StrKey = objItem.Subject & ',' & objItem.StartDate & ',' & objItem.DueDate & ',' & objItem.Body StrKey = objItem.FullName & ',' & objItem.Email1Address & ',' & objItem.Email2Address & ',' & objItem.Email3Address StrKey = objItem.Subject & ',' & objItem.Start & ',' & objItem.Duration & ',' & objItem.Location & ',' & objItem.Body StrKey = objItem.Subject & ',' & objItem.Body & ',' & objItem.SentOn Set objDictionary = CreateObject('scripting.dictionary')įor n = To 1 Step -1 MsgBox 'Error: The two folders are not in same type!', vbExclamation + vbOKOnlyįor i = To 1 Step -1 If objSourceFolder.DefaultItemType objTargetFolder.DefaultItemType Then Sub MergeOutlookFolders_WithoutDuplicates() 'Here we take 'merging two folders' as an example

After that, you should copy the following VBA code into this module.Next, in the “Microsoft Visual Basic for Applications” window, you need to open a module that is not being used.Then, you ought to access the Outlook VBA editor by pressing “Alt + F11” key button in the Outlook main screen.To start with, launch your Outlook application.Merge Items from Multiple Folders without Duplicates Under this circumstance, you can make use of the following VBA code to realize it with effortless ease. In this situation, if there are some duplicated contacts among these folders, you must hope that the duplicates can be removed automatically during merging.

It is using VBA code to help you accomplish it like a cork.Īt times, you may wish to merge items from several Outlook folders, like merging all the contacts of several Outlook Contacts folders. If you would like to merge all the items from multiple Outlook folders and insure no duplicate, you can use the method introduced in this article.

How to merge folders windows 10