[Deejay]

How do I shrink blank lines in a mail merge. Typically one contact may have a
2 line address and another has a 3 line address. How do I ensure that the 2
line address contact doesn't have a blank line before the town/city line? I
know it can be done in Access but can it be done in Word?

Thanks.

[Graham Mayor]

The simplest way which works under all circumstances is to use a series of
conditional fields to insert the line feeds and the mergefields only when
there is data in them eg

{Mergefield fieldname1}{IF {Mergefield fieldname2} "" "
{Mergefield fieldname2} "}{IF {Mergefield fieldname3} "" "
{Mergefield fieldname3} "}{IF {Mergefield fieldname4} "" "
{Mergefield fieldname4} "}

Change the fieldnames as appropriate to your data. All the bracket pairs {}
are inserted with CTRL+F9 and the only line feeds and spaces are placed
where shown.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Deejay wrote:
How do I shrink blank lines in a mail merge. Typically one contact
may have a 2 line address and another has a 3 line address. How do I
ensure that the 2 line address contact doesn't have a blank line
before the town/city line? I know it can be done in Access but can it
be done in Word?

Thanks.