You're getting multiple outputs per recipient because you haven't followed the instructions in the tutorial and as per the examples given in the links there. What you need is a separate Excel Worksheet that has fields for everything that is to appear once per letter and use that as the primary data source.
Your Excel data should also not span multiple lines with breaks - you should use a separate column for each line.
See the attached workbook, to which I've added a 'Debtors' sheet.
I've updated the mailmerge main document and the macro, which now also outputs the case #s on the letter. You will need to re-connect the document to the Excel workbook, selecting the 'Debtors' sheet as the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|