You can conditionally insert the merge fields eg
{Mergefield Field1}{{If {Mergefield Field2} <> "" "
{Mergefield Field2}"}
This will insert
Field1
if there is nothing in Field2
and
Field1
Field2
If Field 2 has content.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
richge wrote:
[Quoted Text] > I'm doing a mail merge in Word with Data from an Excel spreadsheet.
> When the Excel cells are blank, I don't want the blank spaces to
> appear in the Word Mail Merge. Is there a way to prevent the blank
> spaces from showing in the Word doc?
|