View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Nick
 
Posts: n/a
Default Skip Record if Comparison of Several Fields Fails

Thank you for the reply. Need a Word Mail Merge (MM) "Skip Record IF"
solution.

Data compare perception ratings between three products. The target
product could be 1st, 2nd or 3rd choice, or not mentioned. If the
product is rated either better or worse than the products in the other
two positions a paragraph or letter is generated. The MM works fine for
that purpose. However the merge is creating a blank page for the
non-qualifying records. Need a way to Skip the record if:

1. product is not mentioned in any position
or
2. product is mentioned but is not rated better or worse than the
target product