Group records in Word 2003 mail merge

[Irina]

I have a database query as a source of the mail merge.
It does not have grouping in it since it does include an aggegate function.
Data looks something like this:
employee manager rating A explanationA rating B explanationB
Jane Peter 3 nice 4
lots of sales
John Charlie 2 not nice 3
could be better
John Mark 4 nicer 5
best sales person

and so on
I need to create a report in WORD, using mail merge and group the same
employees together. So the performance per each employee is combined for the
same employee, another words review for John done by Charlie and Mark is on
the same page and their ratings and explanations append to each other.
For example, the report needs to look like this:
Review for John
Criteria A
Reviewer: Charlie, Rating: rating A, Explanation: explanationA
Reviewer: Mark, Rating: ratingA, Explanation: explanationA
Criteria B
Reviewer: Charlie, Rating: rating B, Explanation: explanationB
Reviewer: Mark, Rating: ratingB, Explanation: explanationB
I know that this can be done using access report, but it needs to be done in
word.
I started writing the code for the merge but got confused.
Can anyone take a look and suggest solutions? (please do not suggest for
this to be done in access - it is not a choice)
{ IF { MERGESEQ } = "1" "{ MERGEFIELD Employee }¶
" "" }{ SET Place1 { MERGEFIELD Employee }}¶
{ If { Place2 } <> { Place1 }"¶


{ MERGEFIELD Employee }¶
¶
{ MERGEFIELD Reviewer} “Rating: “{ MERGEFIELD ratingA } “Explanation: “{
MERGEFIELD explanationA }" "{ MERGEFIELD Reviewer } { MERGEFIELD Rating B}{
MERGEFIELD ExplanationB }" " { MERGEFIELD Reviewer} { MERGEFIELD RatingC } {
MERGEFIELD ExplanationC }}{ SET Place2 { Employee }}¶

 

[macropod]

Hi Irina,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminolgy depends on the Word version). To see how, check
out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.