You can conditionally merge the fields and their associated line breaks eg
{Mergefield Field1}{IF {Mergefield Field2} "" "¶
{Mergefield Field2}"}{IF {Mergefield Field3} "" "¶
{Mergefield Field3}"}{IF {Mergefield Field4} "" "¶
{Mergefield Field2}"}etc
Change the field names as appropriate and press the enter key only where you
see ¶
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
"Ben K" Ben
wrote in message
...
Hi,
Using Windows Xp I have created a mail merge in word from an Excel
spreadsheet.
I have 5 address columns in my data, but some records only have data in 2
or
3 of these fields. My labels appear with spaces where these fields are
empty.
How do I close these gaps?
Thanks
Ben