Importing from Excel - multiple street fields

C

cally1

I'm importing data from an Excel spreadsheet where the address is separated
out into Business Street, Business Street 2, Business Street 3, City, State,
Postcode. Most of this imports fine but there is no option in the "Map
fields" section for Business Street 2 or 3. I can create a new field for
this but when I open a contact that has been imported the information does
not show up. Can anyone help?
 
L

Luther

I'm importing data from an Excel spreadsheet where the address is separated
out into Business Street, Business Street 2, Business Street 3, City, State,
Postcode.  Most of this imports fine but there is no option in the "Map
fields" section for Business Street 2 or 3.  I can create a new field for
this but when I open a contact that has been imported the information does
not show up.  Can anyone help?

In Excel, merge the two street columns into one, and then import into
BCM.
 
C

cally1

Hi Luther

Thanks but I don't really want to do it that way - I need the data to be on
separate lines so that when I later run a marketing campaign through BCM and
export to a mail merge in Word I am able to have the street address separated
out on different lines. I'm sure there must be a way of doing this!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top