Word doesn't do this "out of the box". I quote from macropod's post
earlier today:
"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%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it."
Peter Jamieson
http://tips.pjmsn.me.uk
Hutch wrote:
I have a spreadsheet where each unique person has a handful of records
listing some classes they are teaching. I would like to present those
classes in the body of a letter in row format. Is there a way to do so and
include only to rows for each unique person and when the next set of rows for
a new person starts it knows to produce a second letter? For example, letter
would look like:
Dear Person AA:
You will be teaching the following classes this semester:
MIS68900A
MIS67900B
MIS6890A
Thank you for agreeing to teach.
***then the mail merge would kick off a letter for a second person
Dear Person BB:
You will be teaching the following classes....
HST6777C
HST5567D
HST7896A
Thank you for teaching these classes this semester.