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
Lon[ at ]pinpointtools.com
www.pinpointtools.com
"Luther" <enowning[ at ]gmail.com> wrote in message
news:1170621899.316695.117430[ at ]h3g2000cwc.googlegroups.com...
[Quoted Text] > On Feb 3, 11:28 am, "Casey Hill" <c...[ at ]newpages.com> wrote:
>> 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.
>
|