I'm currently sending out memos for an in-service that supervisors will be
directing their subordinates to attend.
What I have:
a spreadsheet that details column 1: department# column 2:supervisor name
Column 3: employee name.
2 word documents in memo form that i need to merge #1 goes to the
supervisor, #2 to the subordinates.

What i need:
being that one supervisor has many subordinates, the supervisor would only
need one of #1 to get the information and then each subordinate would get 1
of #2.
i want it to be so that when i print the mail merge, that the first page is
the supervisors memo and the next are the subordinates of that supervisor who
need to attend the inserviceand then the same thing for the next supervisor
and his subs. its about 300 people altogether please help me as soon as
possible my supervisor is hounding me!!!

--
thanks in advance