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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jcontrer - 28 Feb 2008 19:21 GMT

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

Signature

thanks in advance

Reply to this Message

Doug Robbins - Word MVP - 28 Feb 2008 22:05 GMT

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.

Signature

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

> I'm currently sending out memos for an in-service that supervisors will be
> sending their subordinates to.
[quoted text clipped - 17 lines]
> and his subs. its about 300 people altogether please help me as soon as
> possible my supervisor is hounding me!!!

Reply to this Message