Hi bh,

Try the attached. Do note that, unless you separate the source file into two separate files - one for money and the other for goods/services - there is no practical way of having two separate mailmerges. I've altered the donations document slightly to account for this. Also, since I used Word 2003 for this, I had to sort the Excel workbook by donor so that the filtering would work correctly.

Attached Files

WSM.zip (26.6 KB, 1549 views)

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

I am very new to Mailmerge functionality, but really need to learn it. I have reviewed your examples and am confused as to the order of the coding. Why does what appears to be the bottom half of the output come first?

Any guidance would be very much appreciated.

Because it works that way... Basically, what happens is that each new group, except the first, triggers the output of the last part of the previous group's letter before the new group's first part is output.

If you expand the field code for the 'Using One Key' example from page 9 of the tutorial, except for the colouring, you'll see:
In the above, the:
• green content outputs whatever goes at the start of each letter.
• orange content outputs the repeated data.
• red content outputs whatever goes at the end of each letter (technically, {IF{MERGEFIELD State}<> 0 {QUOTE 12}} is part of that).
• blue QUOTE field generates the page breaks between letters.
• purple fields manage whatever you use as the KEY to indicate a change of grouping.
• black content does the housekeeping, pulling all the others together and ensuring you don't get output being generated at the wrong time.
Although the whole field is depicted as a single paragraph with manual line breaks, there is nothing to stop you having multiple paragraphs with a variety of formatting, images, textboxes, etc. for the green and/or red portions.


Note: I've now closed this thread and moved later discussions to separate threads, as this thread was becoming quite long. If you need help with the issues discussed in this thread, please start a new one, linking to this one if necessary.

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