Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Business Contact Manager / May 2008

Tip: Looking for answers? Try searching our database.

tricky merge question!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ian - 28 Apr 2008 12:02 GMT
Hi,
We are trying to link some business contacts to the correct accounts. These
contacts seem to have become orphaned for some reason. There are around 5,500
BCM Business Contacts. The BCM contacts each have “company” names tagged, but
are not linked to an “account”. In parallel, the existing account records all
have other contacts still present ok.

We are trying to automate either a way to link these 5,500 to their
respective accounts (i.e. the existing company name in the field), or to
create new accounts for them all and then "merge" so that each account has
all the right contacts. We would rather not do the latter since we may create
say, 4 new accounts for 4 new contacts and then have to de-duplicate etc.

Put simply, any way to link a large number of BCM contacts in one go would
be great.

All ideas welcome and thanks in advance for any help.

Many thanks.
AnnieBrown - 01 May 2008 03:20 GMT
Maybe export them to a csv file and then fill in the appropriate account name
in the "account" column, then import them all back in.

Just a thought.
Annie

> Hi,
> We are trying to link some business contacts to the correct accounts. These
[quoted text clipped - 15 lines]
>
> Many thanks.
Ian - 01 May 2008 14:18 GMT
Thanks. We'll give this a go.

Much appreciated.

Ian

> Maybe export them to a csv file and then fill in the appropriate account name
> in the "account" column, then import them all back in.
[quoted text clipped - 21 lines]
> >
> > Many thanks.
Luther - 01 May 2008 16:50 GMT
> Thanks. We'll give this a go.
>
[quoted text clipped - 29 lines]
>
> - Show quoted text -

In most places in BCM, the Account field contains the id of the
Account and not the name.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.