I'm running a Mail Merge using Word 2013. I have a list with 3 items on it [Fig. 3], and I have a template that I've written. The template has some basic formatting and displays the line items (1 on each line) with the calculated Total Shipping (Freight), Total before tax, Total VAT amount and Grand Total in separate lines below that. To get to the next line item I am using the NEXT record rule. Each line item shows on its own line, but the Total Shipping, Total before tax and Grand Total do not populate unless I manually update the fields [Fig. 1]. I have played with the NEXTIF rule and I can get those fields to update automatically, but I have 5 lines in the item table and the other lines fill with the first record [Fig. 2]. Can anyone point me in the right direction here? End goal is to have anything from 1 to 5 records/line items in the table and for the bottom fields to populate during the mailmerge.
The NEXTIF rule is populated like so: { NEXTIF { MERGEFIELD "Product_Product_ID" } = "True" }
Thank you kindly
Screenshot of my populated table using NEXT:
Screenshot of populated table using NEXTIF:
Screenshot of the data table: