Related items from different records on one page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CAI Tech Guy - 13 Sep 2006 22:10 GMT

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

Signature

CAI
Partners for a better workplace.

Reply to this Message

Doug Robbins - Word MVP - 14 Sep 2006 04:44 GMT

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

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 have read and applied http://support.microsoft.com/kb/294686/en-us and
> gotten 95% success.
[quoted text clipped - 38 lines]
>
> Any ideas for a solution other than switching to "Directory"?

Reply to this Message

CAI Tech Guy - 14 Sep 2006 13:47 GMT

For simplicity, I really need a solution that keeps me (and the end user) in
Word and Excel (not Access).

Signature

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
[quoted text clipped - 52 lines]
> >
> > Any ideas for a solution other than switching to "Directory"?

Reply to this Message