[thelist] OT -deleting dupLicates in excel document
Brian Cummiskey
Brian at hondaswap.com
Thu May 5 11:41:56 CDT 2005
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 :)
More information about the thelist
mailing list