Hi,

I am not too familiar with the mail merge function in Word. I would like to know if there is a functionnality within word or some vba code to print to a doc file only the records that match a specific criteria.

I.E : I have a field in my excel spreadsheet that indicate if the user speak french (value in field will be french) or english (value in field will be english). The header of this field is Language. I would like to print to a .doc file only the record that have the value "french" as mergefield "Language" value.

Thank you for your help.

Hi nicnad,

You can use Word's SKIPIF field for this. For example:
{SKIPIF {MERGEFIELD Language \* lower} = "french"}
where the field braces (ie '{}') are created by Ctrl-F9.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]