Ask a new question

SKIPIF field in Word 2013

Hello, 

I have a table with a number of address related fields (ex: name, title, company, street, etc.) and a "christmas" field with either an "x" or left empty depending if the person is set to receive a letter on Christmas.

I am using the following syntax

{SKIPIF {MERGEFIELD christmas}=""}{ MERGEFIELD "name"}

{ MERGEFIELD "address"}

{ MERGEFIELD "postalcode"}

 

{NEXT}{SKIPIF {MERGEFIELD christmas}=""}{ MERGEFIELD "name"}

{ MERGEFIELD "address"}

{ MERGEFIELD "postalcode"}

and Word (2013) doesn't seem to pick up on the SKIPIF field at all. When I check the preview, every name is on the resulting list, no matter the value of the "christmas" field in my Excel document.

I don't know if I'm doing it wrong or if the problem comes from me using the French version of Word 2013.

Thank you for your help.

Answer
Answer

I assume that you are performing a label type merge.  My tests have convinced me that a SKIPIF field does not work with labels, no matter where you insert it, or how many times you insert it.

The alternatives are to use Filter facility in the Edit Recipient List utility or to modify the data source so that it only includes the records that you want to be merged.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 14, 2025 Views 2,287 Applies to: