Import more than one address field to business contact manager

[EPSNSW]

I want to import data from excel into Outlook Business Contact Manager but it
only has one address field. The csv file I want to import has 6000 contacts
and most have two address fields.

I want the format to be (like all other database files);
Address Line 1
Address Line 2
City
State
Post Code

 

[Luther]

I want to import data from excel into Outlook Business Contact Manager but it
only has one address field. The csv file I want to import has 6000 contacts
and most have two address fields.

I want the format to be (like all other database files);
Address Line 1
Address Line 2
City
State
Post Code

I think you'll need to merge the Address 1 and 2 columns in Excel and
then import with the merged address column.

 

[Manny]

What if one is using one address line for sub divisions? Is there a hierarchy
function within BCM

for example company ABC has multiple branches, I want the company name to
remain ABC and in another field I want to describe the branch like Calgary
Head office, Calgary Sales office, Calgary R&D

What about contacts who have mailing address, curier address both of which
can be different

 

[Luther]

What if one is using one address line for sub divisions? Is there a hierarchy
function within BCM

for example company ABC has multiple branches, I want the company name to
remain ABC and in another field I want to describe the branch like Calgary
Head office, Calgary Sales office, Calgary R&D

What about contacts who have mailing address, curier address both of which
can be different






- Show quoted text -

Those would be different contacts, with different phone numbers, etc.,
all sharing the same company name.

That's probably why the Business Contact's Company name field is
different from the Business Contact's parent Account field.

One way to organize them in BCM is to consider billing. If you send
one invoice ABC, create one ABC Account, with child Business Contacts
for each person you communicate with, using the Company name to
indicate the branch. If you invoice the branches separately, create
separate Accounts and use ABC in the Business Contact's Company name.