View Single Post
 
Old 11-13-2015, 06:58 AM
eredn eredn is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2015
Posts: 1
eredn is on a distinguished road
Question Mail Merge in Word Does Not Move to Next Field and Input Value

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:
Reply With Quote