[Ben K]

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

[Graham Mayor]

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