Import more than one address field to business contact manager

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EPSNSW - 28 Aug 2007 08:02 GMT

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

Reply to this Message

Luther - 29 Aug 2007 19:03 GMT

> 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
[quoted text clipped - 6 lines]
> 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.

Reply to this Message

Manny - 29 Aug 2007 20:54 GMT

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

> > 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
[quoted text clipped - 9 lines]
> I think you'll need to merge the Address 1 and 2 columns in Excel and
> then import with the merged address column.

Reply to this Message

Luther - 31 Aug 2007 12:12 GMT

> What if one is using one address line for sub divisions? Is there a hierarchy
> function within BCM
[quoted text clipped - 21 lines]
>
> - 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.

Reply to this Message