I have downloaded your catalogue zip file and using that. I am having an issue that I just can resolve. The key1 condition check won't work regardless of what I do. The base code always repeated printing the Key1 value even when it didn't change. I tried to change to only print if Key1 changed and not also if Key2 changed. For whatever reason the Key1 check won't work. I have attached my data, template and template output. I am not worrying about the output format, just trying to get the correct data first. I have structured the template so that I can see the mailmerge sections and have added output to show values as it is running. I have struggled with this for days and I am ready to throw my hands up. Any help would be greatly appreciated.



Greg S.

Attached Files

	LienWaiver Template - Base Working Draft 4 - Results.docx (37.6 KB, 11 views)
	LienWaiver Template - Base Working Draft 4.docx (13.6 KB, 12 views)
	LienWaiver - Test Data.xlsx (82.2 KB, 12 views)

Hi sorreng,

It seems you've mixed up your key usage. Try the attached.

PS: You also appear to be using a superseded version of the tutorial

Attached Files

LienWaiver.docx (14.8 KB, 14 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Barring the poor formatting on my working document, the output without that is identical to what your example shows. The problem is that when the LienWaiverGrp is the same and the paymentnumber changes, the LienWaiverGrp heading still prints. I only want the LienWaiverGrp to print when it actually changes. The first example of this is "0001 CDWCOR Check" There are 2 checks for this vendor. I only want the vendor info printed once on the first check, not once for each change in check.

In that case, why are you using two keys?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I want page breaks for every LienWaiverGrp change and print the vendor information as a header. Then print payment information (#, date, amount) and then print the invoices that are paid by the payment. A vendor can have 1 to N payments, a check can have 1 to N invoices. I don't want to print repeating header information per break levels 1 and 2 more than once.

In that case, I'd suggest using the VendID field, rather than the LienWaiverGrp field for the key. I suspect the issue you're having is that your key string lengths are too long and Word ends up comparing only the numeric portions they start with. In this regard, I note that your VendID records only ever change when the LienWaiverGrp records change.

And, if you use the 'Inserting Content Before the Repeated Data' example from the tutorial, you still need only one key.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]