Merging Conditional Number of Records to same page

[April]

I have to Following Scenario: I have a datasourse that
has a list of names for a Branch, ie

Branch Fname LName EmpID PCC
branchA Mary Jones A12345 Neil Look
BranchA Sue Mirck A23456 Neil Look
BranchA John Doe A34534 Neil look
BranchA John Doe,Jr A34534 Neil look

BranchB Ron Vietel A54309 James John
BranchB Michael Allen A53454 James John


I am trying to sent a Mail merge letter to the PCC at
Branch" "... And I want to include a list of the
employees above that I have for that list. So the letter
to Neil Look would have "I show you have the following
Employees:"

Mary Jones A12345
Sue Mirck A23456
John Doe A34534
John Doe,Jr A34534

And the letter to James John would be: "I Show you have
the following Employees:"

Ron Vietel A54309
Michael Allen A53454

I have tried to follow the directions in the KQ212375,
but I could not figure out how to do it... Can you please
help?

Thank so much in advance, April Pace

PS in the recordsourse it might have 4 to 50 records, for
each branch/PCC... out of the say 341 records in my
Datasourse I will be only creating say 10 letters, one
for each Branch/PCC The datatsource is so long because of
the list of employees for each branch.

 

[Doug Robbins - Word MVP]

Hi April,

I would use a report in Access. Word does not handle this sort of thing
simply.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP