Hi All,


I have a long list of emails for my newsletters but I believe I have some doubles in the list. Do you know a windows software I could use that would notify me of the double email entries I have in my list and automatically delete it.

Regards,

BamBam

http://office.microsoft.com/en-us/excel/default.aspx

This will at least allow you to find duplicate entries. I'm only a Level 2 XLS Wizard Apprentice, you may have to consult a Level 3 or above for help with a macro that will automatically do the deletion as well.

Thanks Mattle,


I will give it a go now.

Regards,

BAmBam

For such tasks I use TextPad (http://www.textpad.com/), a great shareware text editor...

(1) Paste into TextPad.
(2) Ctrl+A to select all.
(3) Right-click > Change Case > Lower Case to normalize the capitalization. (You may need to delete all spaces too.)
(4) Press F9, make sure "Delete duplicate lines" is selected, then click "OK".

Done.