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.
PLEASE REPLY WITH YOUR VOTE FOR SOLUTION 1 (Please spell it out in detail) or SOLUTION 2 or SOLUTION 3 (Please provide it in detail).This macro is slow.
I AM NOT SAYING THAT CASE 2 IS ACCURATE but just pointing out that Solution 2 will not NECESSARILY work.
This algorithm might be chosen for speed as comparing against a static list is faster than comparing against an Imbox that changes after each email is imported. This case would NOT work for me (as the original Inbox is empty so both duplicates will come in) BUT would work for the ususal case. Then it compares each email coming in against that etc. This algorithm will work for my case and usual case too.Ĭase 2: Before the Import starts, Outlook analyzes the Inbox for all emails there and stores them somewhere else. Here are two possible algorithms that would work for the matching emails in the Inbox and the pst to be imported but ONLY ONE will work for my case.Ĭase 1: Outlook compares each email in the pst to be imported INDIVIDUALY with ALL EMAILS in the current Inbox and does not import it if there is already a matching email in the current Inbox. My case is the duplicates are ALL in the file to be imported. It is designed for when there are the same emails in the current inbox AND ALSO in the pst file to be imported. This option is designed for A DIFFERENT SITUATION THAN MINE. It depends on how Outlook achieves the no duplicates. WHY AM I POSTING HERE AS SOLUTION 2 WILL OBVIOUSLY WORK? Solution 3: Other solution provided by EE expert NOTE: BOTH OF THESE OPTIONS EXIST FOR IMPORTING INTO OUTLOOK 2007. Sent, Drafts and all the user created personal folders), import the copy of Outlook.pst, selecting to Import ONLY the Inbox and also selecting NO DUPLICATES (or similar wording). Solution 2: I close Outlook, copy the Outlook.pst file somewhere else (make 2 copes to be safe), open Outlook, delete all emails in the Inbox (leaving all other email folders untouched, ie. But I may have missed something as there are a lot of options and preferences and so on. NOTE: I am 95% sure there is NO such thing, as I have already looked thru the options at length and checked the Outlook help file. Solution 1: EE expert tells me HERE there is an option or preference or whatever ALREADY PART OF OUTLOOK 2007 that says "remove duplicates" or similar.
#Delete duplicate emails in outlook delet folder 2007 how to#
Question: How to get rid of the duplicates ? Also the Inbox emails are no longer on the email server. How it happened is irrelevant to this question and it will not happen for future received emails due to a change I have made. My customer has many duplicate emails (basically last 3 weeks Inbox and he gets a 100 emails a day).