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.
|