multiple address lines

[Casey Hill]

I need to be able to have separate fields for addresses:

Address1
Address2
City State Zip

When I type an address in the Address Details section like

Boston College
123 Main St
Boston, MA 02215

When I export that as a csv file to open in Excel, or simply try to use it
in a mail merge, the 2 lines are combined into one.

I see that you are able to create new forms, and wonder if this is the
solution I should look into.

This is a total show stopper for me. Any ideas or links to where this is
discussed? Anybody done this that can offer some step-by-step?

Casey H

 

[Luther]

I need to be able to have separate fields for addresses:

Address1
Address2
City State Zip

When I type an address in the Address Details section like

Boston College
123 Main St
Boston, MA 02215

When I export that as a csv file to open in Excel, or simply try to use it
in a mail merge, the 2 lines are combined into one.

I see that you are able to create new forms, and wonder if this is the
solution I should look into.

This is a total show stopper for me. Any ideas or links to where this is
discussed? Anybody done this that can offer some step-by-step?

Casey H

From discussion about this in the past, I believe Outlook, Exchange,

and other Microsoft applications only uses a single address field,
although you can have many lines in that single field. Exporting to
CSV usually means one line per record, so they they probably strip the
new-lines from the address field.

 

[Lon Orenstein]

Casey:

Try clicking on the Home or Business button next to the address field in the
Business Contact record. That opens a dialog where you can specify City,
State, Zip, et al. It may be that all your address is in the Street field,
and that's why it exports like that.

HTH,
Lon
_________________________________________________
Lon Orenstein
pinpointtools
(e-mail address removed)
www.pinpointtools.com