Related items from different records on one page

[CAI Tech Guy]

I have read and applied http://support.microsoft.com/kb/294686/en-us and
gotten 95% success.

Article 294686 specifies that the main document should be setup as a
"directory". I got that scenario to work perfectly, however, my real-world
situation calls for more layout and formatting options than a "directory" can
provide. I need to keep my main document setup as a "Letter".

I am trying to get multiple 'contacts' (up to 10) from one 'company' on one
page; one page per 'company'.

Company: { MERGEFIELD "Company" }{ SET Place1 { MERGEFIELD "Company" } }
Contacts:
{ MERGEFIELD "Contact" }
{ NEXTIF { MERGEFIELD Company } = Place1 }{IF { MERGEFIELD Company } =
Place1 "{ MERGEFIELD "Contact" }" "" }
....prior line repeated eight more times...

The first page (for the first company) is perfect, but every page afterward
omits the first contact for that company.

I nailed down the behavior, but I can't craft a solution.
During troubleshooting, I used the "Merge Record #" code to find out when
the document actually called for the next record.

Company: Company One
Contacts:
1John Doe1
12Jane Doe2
233

Whether the "NextIf" code condition is met or not, the next record is tagged
for entry.
In my real world, Company One has two contacts (Record 1 & 2).
Record 3 is snagged on the page for company 1 (it doesn't appear), and it
doesn't get incorporated on the next page for Company Two.

Any ideas for a solution other than switching to "Directory"?

 

[Doug Robbins - Word MVP]

Use a report in Access rather than mail merge, or 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 (probably the same as
the one you have looked at)

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

or at

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm


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

 

[CAI Tech Guy]

For simplicity, I really need a solution that keeps me (and the end user) in
Word and Excel (not Access).
--
CAI
Partners for a better workplace.

Use a report in Access rather than mail merge, or 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 (probably the same as
the one you have looked at)

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

or at

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm


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