I am not using anything currently that will do what I want. Right now I am
using Excel with one address per line. When I add a new addresses however, I
have to re-sort alphabetically and then look line by line for duplicates
which is very slow and annoying. So I am looking for something that will
notify my when I input the new address if it already exists to speed things
up

"John Blessing" wrote:


"Walkman" wrote in message
...
I am new to Outlook, so I am still getting my feet wet and trying to
maximize
the program.

I work for a professional association that has a email contact list of
members of about 1500 different email addresses. When we get new email
addresses to add to our list, i need to be sure that they are not
duplicates
of addresses we already have.

Any ideas on how to do this, without making a separate contact for each
email address in outlook? I tried an excel spread sheet, but that will not
notify me of a duplicate, it will only show me duplicates it I sort it
alphabetically.

For example, if I am adding " to the end of our list, and
that
email address is already in the list toward the top, I need something that
will indicate to me that the address is already there.

I am not sure from your description, what you are using to store the list.
If it is as Outlook Contacts, then OUtlook itself will warn you. If it
really is in a database, then you need to run a Select query.


--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters