Importing from Excel - multiple street fields

[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?

 

[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.

 

[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!