I am trying to print  letters using mail merge from an
excel file that contains multiple records
example
ID Last Name First Name
123 Doe John
234 Alvarez Anne
234 Alvarez Joseph
234 Greene Diana
345 Smith John

I have designed a form in word , one page only which I
need to merge data from this excel file, by breaking down
by ID. If the ID is the same on the next record I need to
grab the next name and put it on the same page.

I can use either 97 or 2000 not by choice but that is what
my  employer has.

I am using mergefield with next if and a check code that I
added to the spread sheet from knowledgebase 105888
But the results are not right it must be syntax but I
can't get it to work.

Results below!

Mr :smith , will

Your case has been accepted:
beth  {set duplicate {if
="1" "off" "on"}} {if
{duplicate}="on" "rose"}

Any real  working examples I can use that has the code and
an input file would be great.

Thanks,

Maria Elena