Keep data in excel in seperate columns when export

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

Guest

I am saving BCM as an Excel file so that I can use it for a special postal
mailing program authorized only by the postal system. When I view the excel
file, everything is okay, except that the address is in one column. I need
to have each part of the address in it seperate column. Is there a way to
accomplish this rather than moving over the information one at a time?
 
If you map the excel column to "Business Address", Outlook will parse
the address into the different fields. You milegae may vary depending
on how the address is formatted (is the address multi-line?). In my
test it included the street address in the city field.
 
This is the process I have done. I have an access program with the data,
have to convert it to excel, then map the excel into BCM. In mapping I have
to map the PO to Business Address, then street address to Business Street,
City to Business City, State to Business State, and Zip to Business Zip. Are
you saying that I can highlight all my excel address data and then move it to
Business Address?

Thanks
 
I don't know what you mean by highlight.

If the Excel spreadsheet has the complete address in a single column,
you can map that to BCM's Address field. During the import, when
Outlook saves the Contact, it will parse the Address field into the
individual fields.

If you already have the address broken down into Street, City, State,
and Zip, use those instead, as they'll be more accurate than depending
on Outlook's address parser.

If the data is already Access, you could try importing it direct into
BCM from Access, without going through Excel first.
 
Back
Top