0

I'm have a mailmerge that will populate all records under the same invoice number for customer. I would like to place a summary of the dispute reason below it. I'm unable to find the right approach to it.

Source Data in excel: enter image description here

Mailmerge code in word: enter image description here

I would like a summary of dispute reason below table (it should not repeat if there are 2 records with same dispute reason):

enter image description here

Stephen Peck
  • 37
  • 4
  • Why, given that you have a Dispute_Reason field, would you not use that instead of the Dispute_Cd field and forego the Dispute Reason list? Moreover, you should consider using a DATABASE field instead of a pre-defined table with all those NextIf fields. For more info, see: https://www.msofficeforums.com/mail-merge/38721-microsoft-word-catalogue-directory-mailmerge-tutorial.html – macropod Sep 19 '22 at 03:03

0 Answers0