In Microsoft Outlook 2003, I am importing from Excel spreadsheets, trying to
consolidate info. I mark "replace duplicates", but it just adds them. So I
have two entries for the same person. What can I be doing wrong?

is the duplicate already in outlook or in the spreadsheet? is everything
identical in both records?
duplicate remover tools are he
http://www.slipstick.com/addins/contacts.htm#dupes

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"A Hinson" A wrote in message
...
In Microsoft Outlook 2003, I am importing from Excel spreadsheets, trying
to
consolidate info. I mark "replace duplicates", but it just adds them. So
I
have two entries for the same person. What can I be doing wrong?

Thanks - I misunderstood and thought as long as the full name was the same,
it would be conisidered a duplicate. I was trying to replace several records
at once that had new contact information. It's not as smart as I thought!
(nor am I).

"Diane Poremsky" wrote:

is the duplicate already in outlook or in the spreadsheet? is everything
identical in both records?
duplicate remover tools are he
http://www.slipstick.com/addins/contacts.htm#dupes

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"A Hinson" A wrote in message
...
In Microsoft Outlook 2003, I am importing from Excel spreadsheets, trying
to
consolidate info. I mark "replace duplicates", but it just adds them. So
I
have two entries for the same person. What can I be doing wrong?

You are correct - it's not very smart. It's better in Outlook 2007, but the
older versions do have problems detecting duplicates to varying degrees.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"A Hinson" wrote in message
...
Thanks - I misunderstood and thought as long as the full name was the
same,
it would be conisidered a duplicate. I was trying to replace several
records
at once that had new contact information. It's not as smart as I thought!
(nor am I).

"Diane Poremsky" wrote:

is the duplicate already in outlook or in the spreadsheet? is everything
identical in both records?
duplicate remover tools are he
http://www.slipstick.com/addins/contacts.htm#dupes

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"A Hinson" A wrote in message
...
In Microsoft Outlook 2003, I am importing from Excel spreadsheets,
trying
to
consolidate info. I mark "replace duplicates", but it just adds them.
So
I
have two entries for the same person. What can I be doing wrong?