mlcktmguy
asked on
Word 2013 Mail Merge Document containing a varying number of lines in the detail
I need to develop a mail merge for my client. The mail merge will be initiated from my Access 2013 application. I have done mail merges many times but always with a one to one relationship between the data and the fields on the document.
In this case I need to develop a mail merge that will have a varying number of 'detail' lines in the body of the document. It's not an invoice but an invoice is similar in construct.
There are certain fields that are only on the document once, such as customer name and address at the top.
In the body of the document, a detail line (Qty Purchased, Product Purchased, Item Price, Extended Price) may appears one or many times. If the customer only bought one item it only appears one time, if the customer bought 10 items that line will appear 10 times and the invoice may overflow to multiple pages.
After all of the purchased products print there is some total information and legal chatter.
Is this construct possible in a mail merge document? I have heard of placing blocks in a mail merge document to accomplish this type of thing but have never done so.
Example:
John Smith 08/17/17
123 Main St.
Hulu, HI 443434
Items purchased
Qty Description Unit Cost Extended Cost
2 Widgets 1.79 3.58
435 Casts 0.45 197.57
Total Due 199.33
The amounts included.........legal drivel
In this case I need to develop a mail merge that will have a varying number of 'detail' lines in the body of the document. It's not an invoice but an invoice is similar in construct.
There are certain fields that are only on the document once, such as customer name and address at the top.
In the body of the document, a detail line (Qty Purchased, Product Purchased, Item Price, Extended Price) may appears one or many times. If the customer only bought one item it only appears one time, if the customer bought 10 items that line will appear 10 times and the invoice may overflow to multiple pages.
After all of the purchased products print there is some total information and legal chatter.
Is this construct possible in a mail merge document? I have heard of placing blocks in a mail merge document to accomplish this type of thing but have never done so.
Example:
John Smith 08/17/17
123 Main St.
Hulu, HI 443434
Items purchased
Qty Description Unit Cost Extended Cost
2 Widgets 1.79 3.58
435 Casts 0.45 197.57
Total Due 199.33
The amounts included.........legal drivel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER