[thelist] OT -deleting dupLicates in excel document

[Brian Cummiskey]

Bruce Gilbert wrote:
> Hello,
> 
> this may be a bit off topic, but I'm in a bind.
> 
> I have an excel document full of company email addresses, that I need
> to send a mass emailing out to. Problem is the filtering of the
> database gave me a document with MULTIPLE email addresses for many
> people. Is there a relatively quick way to get rid of the duplicates
> in excel without doing in manually? We're talking about 6,000 names
> here.
> 
> thanks in advance!

do you have access to a sql database?

if so, just import it into a temp DB table.
then, run
select distinct email_address from tablename

copy paste that list.

shouldn't take more than 2 min :)