Skip record statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryck J - 23 Jun 2004 19:38 GMT

I am trying to create a mailmerge drawing info from an excel spreadsheet. I am trying to limit the records with a skip record stmt. The excel spreadsheet has a column with an @IF that if true returns a blank. Previous inquiries returned adding a switch to my statement.
My first attempt looked like this {SKIPIF{MERGEFIELD To_Print}=""\#"#;;"}
My second attempt was {SKIPIF{MERGEFIELD To_Print\#"#;;"}=""}
The first one didn't limit any records. The second one found no records. Did I miss something?

Reply to this Message

Graham Mayor - 24 Jun 2004 07:23 GMT

The correct syntax would be
{SKIPIF{MERGEFIELD To_Print}=""}
however read the Word help on SKIPIF
A better plan might be to use a conditional field eg
{IF{MERGEFIELD To_Print}<> "" "Do this"}

Signature

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

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

> I am trying to create a mailmerge drawing info from an excel
> spreadsheet. I am trying to limit the records with a skip record
[quoted text clipped - 5 lines]
> The first one didn't limit any records. The second one found no
> records. Did I miss something?

Reply to this Message