title: How do I suppress blank lines in a Microsoft Word 2007 mail merge?
body: <p>I'm setting up a mail merge file that reads from a CSV file.  In the CSV file, there are ~20 Boolean fields that produce the body of the Word mail merge file.  The problem is that if the first 19 fields are all <code>"N"</code>, then the Word mail merge file will have 19 blank spaces and then output the 20th field underneath all of them.  Is there any way to suppress the output of these blank lines using the built-in mail merge rules?
  <hr>
  Here's the header and a sample row of the CSV file:</p>
  
  <pre><code>"firstname","lastname","PRNT1040","LEGALGRD","ACADTRAN","STUD1040","VERWKSIN","VERWKSDP","UNEMPLOY","SSCARD","HSDPLOMA","DPBRTCFT","DEATHCRT","USCTZPRF","SLCTSERV","PROJINCM","YTDINCM","LAYOFFNT","MAJRCARS","W2FATHER","W2MOTHER","W2SPOUSE","W2STUDNT","2YRDEGRE","4YEARDEG","DPOVERRD"
  "Joe","Smith","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","Y"
  </code></pre>
  
  <p>Here's a couple lines of the mail merge file that I'm trying (image linked because copying and pasting of mail merge does not show original document)</p>
  
  <p><img src="https://i.stack.imgur.com/Y0IBK.png" alt="msword_mailmerge"></p>
  
  <p><hr>
  Does anyone know how to get around this?  I tried placing the <code>SKIPIF</code> in front of the conditionals, but that doesn't work either.</p>