Can you export contacts from Business Contact Manager to Excel?

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

Guest

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