#1
|
|||
|
|||
Mail Merge to print specific record based on mergefield criterias
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. |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to multiple .doc files named after a mergefield | nicnad | Mail Merge | 1 | 02-22-2012 01:59 AM |
Mail merge to print each record as it is created | PNGento | Mail Merge | 1 | 01-26-2012 02:00 PM |
avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |
dynamic charts based on mail merge fields | jwajehee | Mail Merge | 0 | 10-05-2011 09:47 AM |
Extraneous record in Word Mail Merge | aldo13 | Mail Merge | 0 | 01-23-2006 01:58 PM |