duplicate contacts

Status
Not open for further replies.
B

Brittan

I'm missing about half my contacts in BCM. I have a backup of an older

Outlook file that is saved to CSV. I can import it into outlook but then

when I drag and drop contacts into BCM I get all duplicates on the names I

still have in BCM. Is there a better way to do this so I don't have to

delete all the duplicates?

I have 1400 contacts so deleting duplicates would take a long time.
 
On 3/1/2010 7:02 PM, Brittan wrote:
> I'm missing about half my contacts in BCM. I have a backup of an older
> Outlook file that is saved to CSV. I can import it into outlook but then
> when I drag and drop contacts into BCM I get all duplicates on the names I
> still have in BCM. Is there a better way to do this so I don't have to
> delete all the duplicates?

> I have 1400 contacts so deleting duplicates would take a long time.

I troubleshoot duplicate contacts using the Excel 2007 remove duplicates

feature.

It's a little tricky, but in a nutshell, I would do an export of BCM and

an export of Outlook contacts.

I would then overlay the data in both files so the fields for name and

e-mail addresses line up.

BCM data would be on the top and Outlook data would follow.

I'd usually also colorize the cells to visually see which contacts

something belongs to.

After that, I'd run the remove duplicates feature on the column. It will

keep the first match it finds and delete every other match.

Then I'd import that file, after some additional cleanup back into BCM.

Leonid S. Knyshov

 
That sounds like a great plan but the other problem I'm having is whenever I

import or export BCM it shuts down outlook. I don't have any problems with

import/export of normal outlook databases just the BCM database. Any

thoughts to another option?
 
On 3/2/2010 2:12 PM, Brittan wrote:
> That sounds like a great plan but the other problem I'm having is whenever I
> import or export BCM it shuts down outlook. I don't have any problems with
> import/export of normal outlook databases just the BCM database. Any
> thoughts to another option?

I would fix the export problem. Are your BCM backups completing

successfully?

There are lots of tools to deal with duplicates available, by the way.

I've tested some of them, but I really prefer my Excel approach even

though it's not for everyone.

Which BCM are we working with anyway? I am assuming 2007, but correct me

if that's wrong.

Anyway, I am done with this thread, let's work on your other issue in

your other thread.

Leonid S. Knyshov

 
Status
Not open for further replies.
< Business Contact Manager Marketing Campaign default address | BCM Setup Problem >
Similar threads
Thread starter Title Forum Replies Date
J Duplicate contacts Using Outlook 1
D Isn't there an easy way to remove duplicate contacts in outlook? Using Outlook 1
I Duplicate contacts in iPhone resulting from LinkedIn connector in Exchange Using Outlook 3
A Remove shared Contacts duplicate entry Using Outlook 3
M How to clean duplicate/empty e-mail address fields in Outlook contacts Using Outlook 0
Rupert Dragwater Duplicate email in Folder Using Outlook 7
L Duplicate calendar entries in Outlook 365 Using Outlook 3
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
D Duplicate Emails on Phone and Tablet Using Outlook 0
I Google Calendar <calendar-notification@google.com> appearing as a duplicate entry Using Outlook 2
O Delete duplicate emails - subscription notifications Using Outlook 5
T Deleting duplicate emails Using Outlook 2
S Receiving duplicate messages from RSS feeds Using Outlook 3
M Duplicate Primary Mail Accounts outlook 2010 Using Outlook 0
C Auto categorize duplicate subjects Outlook VBA and Custom Forms 11
K Outlook 2010 duplicate download emails 1 inbox 1 PST no updates Using Outlook 3
C Don't forward duplicate Using Outlook 0
E Duplicate, nested account folders on ATT server Using Outlook 10
S Duplicate emails Using Outlook 2
O Remove duplicate mail items Outlook VBA and Custom Forms 6
F Avoid sending duplicate using Outlook script Outlook VBA and Custom Forms 2
O How to delete duplicate RSS messages? Using Outlook 6
MattC Problem with Outlook 2007 & iCloud / duplicate tasks Using Outlook 1
Horsepower Duplicate RSS feeds Using Outlook 5
M How to duplicate content of one field in another field? Outlook VBA and Custom Forms 3
P Duplicate Standard Views Using Outlook 3
T Duplicate emails in different "sent" boxes. Using Outlook 2
N Deleting Duplicate Calendar Entires Outlook VBA and Custom Forms 2
J Duplicate Reminders Using Outlook 5
J Duplicate Attachments in Content.Outlook Using Outlook 4
J Duplicate emails on some computers, but not on others Using Outlook 1
M best duplicate contact remover? Using Outlook 6
Mr Mayor Duplicate Task LIST, not "duplicate tasks".... Using Outlook 10
V Duplicate and triplicate messages in Inbox Outlook 2013 Using Outlook 20
M How to remove duplicate history items BCM (Business Contact Manager) 7
H Duplicate E-mails and Wetransfer Using Outlook 4
J Duplicate email when receiving email sent To: me and CC to a group I belong to Using Outlook 16
O Duplicate folders in Outlook 2003 Using Outlook 3
C duplicate e-mails from gmail? Using Outlook 1
T Outlook 2013 Duplicate Recipients Using Outlook 9
wisedave Duplicate Emails Downloading Everytime I Open Outlook Using Outlook 1
C Duplicate emails from pop but only for certain date range? Using Outlook 4
S Duplicate Read Receipt Using Outlook 4
S can't delete duplicate account under Outlook 2007 (Win 7) Using Outlook 16
R Duplicate tasks Outlook 2010 Using Outlook 1
C merging duplicate files Using Outlook 3
P How to remove duplicate history items? BCM (Business Contact Manager) 1
E Duplicate items in contact custome form Using Outlook 1
J Outlook downloads duplicate emails from POP3 account Using Outlook 1
B Need to merge PST, and remove duplicate items Using Outlook 3

Similar threads

Back
Top