Directory Mail Merge into table using unique key and page break
I have a data source that contains SALESPERSON, STATUS, CONTRACT VALUE, CUSTOMER NAME.
Thanks to the posts in this forum I have been able to produce some code that formats the merge so it looks like the below:
CUSTOMER NAME / STATUS / CONTRACT VALUE
The 2nd line repeats until the salesperson changes in the data source. It then creates a page break and starts again.
What I am now trying to acheive is to have customer name, status & contract value populate in a table; When the salesperson changes it will create a new document and do the same again. I have no idea where to start. The idea is that when I have cracked it we will use it to merge invoices into emails to send to our sales people. Any help would be greatly appreciated.