REMOVE BLANK LINE IN MAIL MERGE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nancie - 09 Dec 2007 01:47 GMT

I am using Office 2007 and can't get see where to tell my mail merge (data is
a .csv file) to remove the blank line if no data exists. Does anyone know?

Reply to this Message

Graham Mayor - 09 Dec 2007 06:18 GMT

Although the old mailmerge helper, which contained that options is still
buried in the program, with that option, which may even still work (you can
add the command to the QAT (Quick Access Toolbar) ) the better way is to use
conditional fields eg

{Mergefield Fieldname1}{IF {Mergefield Fieldname2} <> "" "
{Mergefield Fieldname2}{IF {Mergefield Fieldname3} <> "" "
{Mergefield Fieldname3}{IF {Mergefield Fieldname4} <> "" "
{Mergefield Fieldname4}etc

Use CTRL+F9 for the field brackets if entering directly from the keyboard.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> I am using Office 2007 and can't get see where to tell my mail merge
> (data is a .csv file) to remove the blank line if no data exists.
> Does anyone know?

Reply to this Message