PC Review


Reply
Thread Tools Rate Thread

Can you export contacts from Business Contact Manager to Excel?

 
 
=?Utf-8?B?YmVkd2FyZHM=?=
Guest
Posts: n/a
 
      17th Jan 2006
I recently set up all of my contacts in BCM, which has been a great upgrade
to Outlook. However, I have a need to share my contact list with a business
partner in another state, and I would like to e-mail the contact list to him.
I exported the file as a Comma Separated Values file, but all of the
information for each contact showed up in one cell. (i.e. first contact all
in A1, second all in A2, etc.)
Is there any way to export this into a usable Excel file? (Please don't get
too technical in your response. I am just learning and the online help so far
has not been helpful.) Thanks
 
Reply With Quote
 
 
 
 
Luther
Guest
Posts: n/a
 
      18th Jan 2006
You can import the CSV into Excel. Then in Excel, select the first
cell-column, use menu Data|Text to Columns to convert the columns to
excel cells. In the BCM generated CSV file the columns are
comma-separated.

 
Reply With Quote
 
=?Utf-8?B?YmVkd2FyZHM=?=
Guest
Posts: n/a
 
      18th Jan 2006
Thank you for the suggestion. This did separate information into columns, but
the result was unfortunately still unusable. The information was not broken
out in a usable format. Each column had different information by row. (For
instance, in one of the new spreadsheet, the last name of the person is
listed, but the next row down in the same column, the last name is followed
by part, but not all, of the company name.) I tried using different
delimiters (tab, space, etc.) with the same type of results. Any additional
thoughts?

"Luther" wrote:

> You can import the CSV into Excel. Then in Excel, select the first
> cell-column, use menu Data|Text to Columns to convert the columns to
> excel cells. In the BCM generated CSV file the columns are
> comma-separated.
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export adresses from business contact manager into excel Captain Microsoft Outlook BCM 0 7th Jan 2009 10:46 AM
Export contacts in Business Contact Manager 2007 =?Utf-8?B?amJlYXJkNw==?= Microsoft Outlook BCM 13 9th Mar 2007 11:24 PM
How do I export Business Contact Manager contacts for import into. =?Utf-8?B?YWl0Y2hwZWU=?= Microsoft Outlook BCM 1 4th Jan 2005 11:51 PM
How do I export Outlook contacts to Business Contact Manager? =?Utf-8?B?YnJpYW5tYW40NQ==?= Microsoft Outlook BCM 3 10th Nov 2004 05:17 PM
How do I export Outlook contacts to Business Contact Manager? =?Utf-8?B?YnJpYW5tYW40NQ==?= Microsoft Outlook BCM 0 9th Nov 2004 11:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:28 AM.