View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
HUTCH HUTCH is offline
external usenet poster
 
Posts: 2
Default Mail Merge info into a table

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.