Skip record statements

R

Ryck J

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

Graham Mayor

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"}

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top