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