Word Mail Merge From Excel Data

R

richge

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?
 
G

Graham Mayor

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Top