Posted on 2004-09-20
Last Modified: 2010-04-08
I seem to be getting duplicat emails can anyone help?
Question by:aijmexico
LVL 21

Expert Comment

ID: 12106960
Possibly.  What version of Outlook are you using?  

Is this email received via Exchange Server, POP3, or IMAP?

Accepted Solution

deepthiji earned 500 total points
ID: 12107093

You could write some sort of VBA program to take care of duplicates, but the (kinda convoluted) process below using Microsoft Excel should work for you and takes just a minute or two (excluding the import/export time which might take a while if you have a whole lot of data in the folder).

To get rid of your duplicate emails try this:

1.  Go to folder with duplicate email messages
3.  Choose "Comma Seperated Value (Windows)" and save the file to your desktop.
4.  Open the CSV file on your desktop in Microsoft Excel
5.  Highlight all cells containing your data
6.  Choose DATA->FILTER->ADVANCED FILTER and set it to "Filter the list, in-place" and check "Unique records only", then click OK.
7.  Now choose EDIT->COPY, then open a new Excel worksheet, and choose EDIT->PASTE.
8.  Save the new worksheet as a CSV file and close Excel
9.  Open Outlook, create a new folder (just in case) and go to the new folder.
10.  Choose FILE->IMPORT&EXPORT->IMPORT FROM ANOTHER FILE OR PROGRAM->CSV(WINDOWS) and walk thru the rest of the wizard with the default options.

Hopefully, you now have a new folder with all of your email but no duplicates.  If so you can replace the contents of the original folder with the contents of the new folder you created to import into.

check these too......
LVL 21

Expert Comment

ID: 12107174
Hey, that looks familiar???

But, the process above removes the duplicates you already have.  First you want to stop the duplicates from coming in.  If it's POP3 email it's usually caused by a message stuck on the mailbox with a malformed header.  Normally you just access the mailbox from a webmail resource, delete all the junk mail (which is usually what causes this) and you are done.  But that's why I'm waiting for definitive info on what type of mail server is involved here.
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 13

Expert Comment

ID: 12110096
Are you using a PDA with activesync by any chance?

Author Comment

ID: 12139526
This is windows XP and MSO Outlook2002
LVL 21

Expert Comment

ID: 12143227
OK, working on the assumption that this is a POP3 account, since we still don't have the answer to that question:

1.  Go to or
2.  Log on with your email address and email password
3.  Delete any messages from the mailbox that you have already received + delete any spam messages
4.  Open Outlook and see if the problem is resolved.
LVL 21

Expert Comment

ID: 12480992
aaarrggghh, the injustice of it all !!!!!!!!!!!!!!

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question