Hi,

I am looking to create invoices with a mailmerge from an excel list. There are multiple line items to be invoiced for one Fund. I have tried adapting the code in this thread:
https://www.msofficeforums.com/mail-...nt-dollar.html

with



{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}
"{IF{QUOTE{MERGEFIELD FirstOrganization}}<> {Key}
"{IF{MERGESEQ}> 1 {QUOTE 12}}{MERGEFIELD FirstOrganization \f " "}{SET Key {QUOTE{MERGEFIELD FirstOrganization}}
Date
"} {MERGEFIELD Item1}
"}
But I get this as a result:

Organisation Organisation Item1

(1 organisation has many items, and I want the invoice to show Organisation with list of Items).

Help is greatly appreciated!! Thank you.