Unique Email Addresses in Address Book

  • Thread starter Thread starter ItsMe
  • Start date Start date
I

ItsMe

I have a big problem in maintaining contacts using Windows Address Book.
Same email address is stored under different names.

I have enabled "Automatically Put people I reply in my Address Book" options
in Outlook Express in order to save the address to WAB automatically.

But, people often change the their name (not email address). In this case, I
have a lot of duplicated email addresses.

Is there a way to make the Email Address uniques and sort of "Primary Key"
in WAB so that it will not be duplicated?

Please help me

Thank you
 
ItsMe said:
I have a big problem in maintaining contacts using Windows Address
Book. Same email address is stored under different names.

I have enabled "Automatically Put people I reply in my Address Book"
options in Outlook Express in order to save the address to WAB
automatically.

But, people often change the their name (not email address). In this
case, I have a lot of duplicated email addresses.

Is there a way to make the Email Address uniques and sort of "Primary
Key" in WAB so that it will not be duplicated?

Please help me

Thank you
Click to expand...

Try going to the name you want and changing it. Also uncheck the option to
automatically put people in your address book. You can add the sender by
right bright clicking in the message and selecting the option to add the
sender. Good luck.
 
Since I receive a lot of mails from our new and existing clients, adding
them manually is another big work for me. Further, it how do I know whether
that person is already added?
If there is no way, If we can make script to remove duplicate email accounts
from WAB database, it will be fine.
Any ideas?

Thank you
 
ItsMe said:
Since I receive a lot of mails from our new and existing clients,
adding them manually is another big work for me. Further, it how do I
know whether that person is already added?
If there is no way, If we can make script to remove duplicate email
accounts from WAB database, it will be fine.
Any ideas?

Thank you
Click to expand...

There will be a dialog telling you that the address has been added.
 
I have a big problem in maintaining contacts using Windows Address Book.
Same email address is stored under different names.

I have enabled "Automatically Put people I reply in my Address Book"
options
in Outlook Express in order to save the address to WAB automatically.

But, people often change the their name (not email address). In this
case, I
have a lot of duplicated email addresses.

Is there a way to make the Email Address uniques and sort of "Primary
Key"
in WAB so that it will not be duplicated?

Please help me

Thank you
Click to expand...

Not Directly. Since you used the words "primary key" I will assume you have
at least a surface knowledge of Relational Database.

Back up address book first before attempting any of this!

Either A)

Export your address book to a text file (*.csv). Import it into a
database or spreadsheet program. Mangle the file to get rid of dupes. I
suggest sorting by the email address field and manually deleteing and/or
merging duplicate records. delete your old address book And then re-import
the resulting file.

If you use a database program you can use this (untested) query to only
show dupes.

Select * from ABOOK where EMAILADDY in (select EMAILADDY from ABOOK where
count (EMAILADDY) >1 ) order by EMAILADDY;

Field names, table name and EXACT syntax may vary.

Repeat every so often.

Or B)
Find an address book manager that better suits your needs. The Web is a
wonderful thing.
 
Back
Top