How do you mail merge multiple records on the same page

[MariaElena]

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

 

[Doug Robbins - Word MVP]

Hi Maria,

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Badger]

Maria, have you managed to sort the merge problem out yet ?
If not, can give you some help.

Regards
Paul