tiered mail merge

[jcontrer]

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

 

[Gord Dibben]

What you are asking would seem to me to be a function of your Word mailmerge
setup and not an Excel issue.

Assuming you are using Word for the mailmerge and Excel for the source see these
sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP