Import more than one address field to business contact manager

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
Click to expand...

I think you'll need to merge the Address 1 and 2 columns in Excel and
then import with the merged address column.
 
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
 
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 -
Click to expand...

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.
 
Back
Top