Microsoft Word Experts Please

[DaveShoelace]

Afternoon All,

I have a word document that has hundreds of email addresses on it, many of which are repeated several times. I want to find a way of locating the email addresses which are duplicated so I can delete them so I don't send emails twice.

Anyone got any clue how I can do this? I know how to look for specific words that have been duplicated, but not when I don't know what is potentially being duplicate (if that makes sense).

cheers

[millidonk]

Afternoon All,

I have a word document that has hundreds of email addresses on it, many of which are repeated several times. I want to find a way of locating the email addresses which are duplicated so I can delete them so I don't send emails twice.

Anyone got any clue how I can do this? I know how to look for specific words that have been duplicated, but not when I don't know what is potentially being duplicate (if that makes sense).

cheers

Copy and paste into excel and hit the remove duplicate button, then copy back into word

[outragous76]

paste the address into "find" feature - keep hittting find next then delete

you will be done in no time

[millidonk]

paste the address into "find" feature - keep hittting find next then delete

you will be done in no time

I had a file with 19,000 email addresses earlier today. ^^^ method would hurt/poss kill me.  But if you only have a few then it might be worth while.

[outragous76]

paste the address into "find" feature - keep hittting find next then delete

you will be done in no time

I had a file with 19,000 email addresses earlier today. ^^^ method would hurt/poss kill me.  But if you only have a few then it might be worth while.

yes dont do this if you have 19,000 addys!

[DaveShoelace]

paste the address into "find" feature - keep hittting find next then delete

you will be done in no time

I had a file with 19,000 email addresses earlier today. ^^^ method would hurt/poss kill me.  But if you only have a few then it might be worth while.

yes dont do this if you have 19,000 addys!

I actually had about 2000, but I spent the last hour putting each one on a seperate line of word then c&p into excel as milligan suggested - worked a treat, thanks one and all

[millidonk]

A geeky tip for ya, if ever in the same boat again and you fancy saving yourself an hour or so messing about in word. Select all the text in word, copy into a text pad, save it, go to excel, open the txt file within excel and it will give you the option something along the lines of delimited text file, seperated by tabs, commas or spaces, hit ok and this will sort it out for you all nice and neat in seconds then you can dedupe the lot. Have fun.

[Pawprint]

A geeky tip for ya, if ever in the same boat again and you fancy saving yourself an hour or so messing about in word. Select all the text in word, copy into a text pad, save it, go to excel, open the txt file within excel and it will give you the option something along the lines of delimited text file, seperated by tabs, commas or spaces, hit ok and this will sort it out for you all nice and neat in seconds then you can dedupe the lot. Have fun.

What he said 

[Jon MW]

What he said - except you can usually just copy and paste straight from Word into Excel

If it doesn't sort it straight out away then 'text to columns' is the function you need to use - and if that doesn't work it out then saving it as a text file and opening it wouldn't either.

[h]

What he said - except you can usually just copy and paste straight from Word into Excel

If it doesn't sort it straight out away then 'text to columns' is the function you need to use - and if that doesn't work it out then saving it as a text file and opening it wouldn't either.

think the point of putting into note pad is abilty to save file as csv
which when you then open in excel use text to colum with qaulifier of comma

if it was me would keep all data in excel and mail merge into word when required makes editing must easier

[RED-DOG]

Have you tried turning it off and on?

[Jon MW]

What he said - except you can usually just copy and paste straight from Word into Excel

If it doesn't sort it straight out away then 'text to columns' is the function you need to use - and if that doesn't work it out then saving it as a text file and opening it wouldn't either.

think the point of putting into note pad is abilty to save file as csv
which when you then open in excel use text to colum with qaulifier of comma

if it was me would keep all data in excel and mail merge into word when required makes editing must easier

I guessed that - I was saying it wasn't necessary, you can just paste it into excel instead of notepad and cut out the middle step.

But agreed, I would usually tend to have it in excel to start with anyway.

[doubleup]

Since when did spammers care about sending their spam out twice?