how do I import Outlook ocntact info into Business Conact Manager

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

Guest

Seems to me like importing Outlook contacts into Business Contact Manager
woudl be a simple proceedure. It may be if you know how. Anybody know how!
 
Hello, msellards!
You wrote on Tue, 29 Mar 2005 20:03:03 -0800:

m> Seems to me like importing Outlook contacts into Business Contact
m> Manager
m> woudl be a simple proceedure. It may be if you know how. Anybody know
m> how!

From inside of Outlook, you simply go to contacts, and in the left hand
corner, you'll see "Contacts in Business Contact Manager". Just drag the
contact's information there, and it copies (I used Right click and copy).

As far as importing from other programs, Microsoft is going to build it into
certain ones, and I would imagine that the Office SDK and the SDK's for the
various programs (Such as SBA, which has it's own public newsgroup) will
have scripts you can use for other programs. Although I'm not entirely
sure how well it would work with say QuickBooks or other competitor's
programs.

With best regards, Patrick Dickey. E-mail: pd1ckey43**RemoveThis**@msn.com
 
I tried importing Business Contacts from a good .csv file. I tried both
mapping the address field to the business address field and to the home
address field. After the import in both cases the city, state and zip show
up on the business card view but the address does not. Is there a way I can
look into the SQL database to see if that field is present? Everything else
came out fine.
 
Hal said:
I tried importing Business Contacts from a good .csv file. I tried both
mapping the address field to the business address field and to the home
address field. After the import in both cases the city, state and zip
show
up on the business card view but the address does not. Is there a way I
can
look into the SQL database to see if that field is present? Everything
else
came out fine.
Click to expand...

So you still have this problem?

You can look at the database with SQL Management Studio.Nevermind that it
talks about SQL Express. It works for MSDE.

Look at
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/MgSQLExpwSSMSE.doc
(or http://tinyurl.com/o4muh )

I think that address data is winding up in wrong columns. You can try using
a Table view in Outlook and add extra columns as well.
--
Leonid S. Knyshov, CEO
Crashproof Solutions, LLC - http://www.crashproofsolutions.com
MCP Exchange 2003/Small Business Server 2003
Microsoft Small Business Specialist Partner
See the tips and tricks section on my website for video tutorials on BCM
 
I tried to import a .csv file into business manager for outlook 2007. After
5 tries I have it all right except: The Value column from the .csv file has
HOUSE Number and STREET while the BCM column has Home Address........ I
drag the house number to home address but houw do I get the Street Name in if
there is not a related field? my address looks like 544,Lexington, KY,
40513 with no street
 
A possible work around will be to combine the 2 columns (House number &
Street) into 1 column in the .csv file before performing the import. The
combination can be quickly done in Excel using the CONCATENATE function. The
formula in the new column might look like this
=CONCATENATE(E2," ",F2) or =(E2 & " " & F2)

Hope this helps....
 
A possible work around will be to combine the 2 columns (House number &
Street) into 1 column in the .csv file before performing the import. The
combination can be quickly done in Excel using the CONCATENATE function. The
formula in the new column might look like this
=CONCATENATE(E2," ",F2) or =(E2 & " " & F2)

Hope this helps....
 
Back
Top