Substituting a value using MERGEFIELD
My Excel 2010 spread sheet's source data field contains a value of "YES" or "NO". My Word 2010 template's merge field causes either "YES" or "NO" to appear in its place in the merged document. Is there a way to define the merge field to cause the word "email" to be inserted instead of "YES" and for "hardcopy" to be inserted instead of "NO"?
|