Combining two different records into one

[JemmyRi]

Hi Everyone,



I'm a bit new to this mailmerge thing but I've spent half a day on it and just can't seem to get it to work. I've got some basic programming knowledge but mailmerge is just so different from everything that I'm used to.

Situation (sorry if I get any terminology wrong):
- I'm using mail merge line items in a table, and each line pulls out different components of a record.
- This gets fed into my accounting software which generates invoices (The software lets me upload docx files as invoice templates. These files use mailmerge code to fill in the details of each invoice).

Example mail merge code in the docx file


Example output on the invoice (recreated in Excel for simplicity)


Question
As shown in the picture above, how do I combine components of two different records into the same record? If someone could post some example code that would be great...

Thanks for your time, hope you can help

[macropod]

There are two issues with your mailmerge:
1. Whatever the process is, it uses an addin that employs non-standard fields. The TableStart:LineItem and TableEnd:LineItem codes evidences that. Consequently, what you can do may be limited by what your software supports - unless, of course, you can access the database via a standard Word mailmerge.
2. Assuming you have the required flexibility, the next issue is: How would the mailmerge process identify which records to combine? Indeed, are they different records, or are they perhaps different fields from the same record?