[4charity]

I am creating a MailMerge letter using data from a query in Access. I would
like the letter to show the [InvoiceNumber] and I[nvoiceAmount] from several
records in Access for the same [Vendor], all in one letter. I am getting
multiple letters, with one record in each.

This is what I've tried, but it's not working. Any ideas?

(IF(MERGESEQ)="1" "(MERGEFIELD Vendor)" "")
(SET Vendor1(MERGEFIELD Vendor))
(IF (Vendor2)(Vendor1)"
(MERGEFIELD Vendor)

(MERGEFIELD InvoiceNumber)(MERGEFIELD AmountInvoiced)" "(MERGEFIELD
InvoiceNumber)(MERGEFIELD AmountInvoiced)""(MERGEFIELD
InvoiceNumber)(MERGEFIELD AmountInvoiced)"(MERGEFIELD
InvoiceNumber)(MERGEFIELD AmountInvoiced))(SET Vendor2(MERGEFIELD Vendor))

Note - the () are really the squiggly brackets.

As an aside: All of the vendors are the same for the records - so I think
there is some extra code in there, but I modified this from somewhere else,
and haven't figured out what to get rid of, but I don't think that matters,
since the [Vendor] info is the same for all records.