2 merges, each supervisor gets 1 and his subordinates get another.

[jcontrer]

I'm currently sending out memos for an in-service that supervisors will be
sending their subordinates to.
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!!!

 

[Doug Robbins - Word MVP]

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge (actually a variation of that) which Word
does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://cornell.veplan.net/article.aspx?&a=3815

Really the simplest thing to do might be to create a second data source that
contains just the fields and necessary to product the supervisor pages and
then execute each merge separately and then manually collate the pages.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP