Mail Merge using excel sheet

[lyn2086]

Hello, I am new here and I hope someone can help me. I am trying to create a template in word 2010 for our bills paid for the month. I created a mail merge using an excel sheet that will change monthly. One month there may be 5 lines and then the next month there may be 25 lines depends on the number of bills paid that month. Is there a way in Word 2010 to create the list on my template with only 1 or 2 lines and a line for the total that can expand or compress as per the data in the excel sheet? I have tried using NextRecordIf but it does not automatically add or remove additional lines in my template. I have attached a sample of the templates (2 word template files and the excel source file).

In file: merge test document.docx - I have the total as part of the PAYEE column
In file: merge test document 2.docx - I have the total as a separate mail merge field and I can not get the total to show when I preview results.