Mail merge address field.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ric - 17 Feb 2004 15:04 GMT

I am doing a mail merge in Word 2003. The address field
that I'm working with contains all address information in
one field. The format of the field is
(address1;address2;city state zip)

I would like this merged onto my document as
address1
address2
city state zip

Is there any way to have word insert a carriage return
when it encounters a ";" in this field so my address
appears properly?

Reply to this Message

Graham Mayor - 17 Feb 2004 15:36 GMT

What's the nature of the data file?

If the data file is suitable, you can tell Word to treat ; as a field
separator.

If the presence of other fields in the data file is causing a problem, then
merge the field to a new document and use that document as a data file.

The only other way that comes to mind would be to merge to a new document
and use replace to swap the semicolon for a return.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am doing a mail merge in Word 2003. The address field
> that I'm working with contains all address information in
[quoted text clipped - 9 lines]
> when it encounters a ";" in this field so my address
> appears properly?

Reply to this Message

Rich - 17 Feb 2004 17:03 GMT

The data file is from a 3rd party product and is a csv
file.

Thanks;

Rich

>-----Original Message-----
>What's the nature of the data file?
[quoted text clipped - 23 lines]
>
>.

Reply to this Message

Graham Mayor - 18 Feb 2004 06:26 GMT

Does it have more than the one field containing the address?
If it does, then I guess the second of my suggestions would be the only
possible one.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> The data file is from a 3rd party product and is a csv
> file.
[quoted text clipped - 40 lines]
>>
>> .

Reply to this Message