In essence, Word should output a copy of all the text and fields in the Mail
Merge Main Document, inserting the values for each Merge field (MERGEFIELD,
ADDRESSBLOCK etc.) from each row in the data source.

My guess is that your Excel sheet is set up so that you have, e.g.

First row: Course name and date, and info. for the first candidate
Second row: blank course name and date, and infor for the second candidate
etc.

If so, the simplest thting to do is change your Excel sheet so that is that
all the data for each row. The alternative is, in my view, unnecessarily
complicated although I can suggest how you could do it if you want.

If not, how is your excel data laid out?

Peter Jamieson
wrote in message
oups.com...
Hello I am trying to automate a tedious operation in our office,
certificate printing. Currently we send out certificates produced in
Powerpoint 2000. We manually type in the candidate name, course, and
date for each certificate. I would like to do this with a mail merge.
I have redone our course certificate template in Word 2000 and have all
the data setup in an Excel spreedsheet. My problem is that the first
certificate prints propely but the remainder only have the candidate
names on them. How do I setup the mail merge to repeat the course name
and date for the remainder of my candidate names?