How do I eliminate duplicate addresses from multiple lists?

[Guest]

Just moved to Exchange from GroupWise. I maintain seperate address lists in
excel and access and some of the addresses are in both lists. In GroupWise I
could copy an entire column of addresses from an Excel spreadsheet into the
To: box and blanks would be eliminated, then I could copy a column of
addresses from an access database into the To: box and both blanks and
duplicate email addresses are eliminated. How can I configure Outlook to do
this?

 

[Brian Tillman]

Just moved to Exchange from GroupWise. I maintain seperate address
lists in excel and access and some of the addresses are in both
lists. In GroupWise I could copy an entire column of addresses from
an Excel spreadsheet into the To: box and blanks would be eliminated,
then I could copy a column of addresses from an access database into
the To: box and both blanks and duplicate email addresses are
eliminated. How can I configure Outlook to do this?

Blanks between addresses won't matter in Outlook, but it won't remove
duplicate addresses in any of the recipient lists. Outlook does what it's
told and if you tell it to include the same address twice, it's happy to do
so.