How can I delete duplicating email addresses?

[Guest]

I'm sending mass email, and copying and pasting the email addresses from an
excel file. There are some duplicating email addresses in the "To" field, so
I'd like to automatically remove duplicating email addresses. For example,
instead of, "(e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed),
(e-mail address removed)" I'd like to see just "(e-mail address removed)".

Is there a function to do this automatically instead of manually? Thanks!!

 

[Vanguard]

I'm sending mass email, and copying and pasting the email addresses
from an
excel file. There are some duplicating email addresses in the "To"
field, so
I'd like to automatically remove duplicating email addresses. For
example,
instead of, "(e-mail address removed), (e-mail address removed), (e-mail address removed),
(e-mail address removed),
(e-mail address removed)" I'd like to see just "(e-mail address removed)".

Is there a function to do this automatically instead of manually?
Thanks!!

So eliminate the duplicates back in your Excel spreadsheet. Ask in an
Excel group how to sort, find duplicates, or write a macro to eliminate
duplicates.