MSAccess: Multiple Items On One Page

[Andy]

Hi;

Using Office 2K, (Access Database, Word Merge)

Have a sales agreement in Access that needs to be "Mail Merged" into Word.

Like all sales aggreements the database records the salesperson's name, the
customer name address & phone number and the products bought.

What happens when the data is merged is that the products are each listed on
a seperate page.

Neither of the solutions below worked.

Already tried going to page setup and making the sections continous and also
from Microsoft help tried:
Q212375 How to Merge Conditional Number of Records to Same Page
It gives this example:
Sample Data File:
Employee Project Check
Scott Cooper 4578j
Scott Cooper 86785x
Scott Cooper 543p 1
Meng Phua 87x
Meng Phua 89976m 1
Kim Yoshida 7897r
Kim Yoshida 857t
Kim Yoshida 78974x
Kim Yoshida 7868p 1

Set up the main document as follows, with a copy of the conditional
statements equal to the maximum number of projects for each employee (four
in the above example).
Employee Project
{MERGEFIELD Employee} {MERGEFIELD Project}{set duplicate {if
{MERGEFIELD Check}="1" "off" "on"}}{nextif {mergefield check}=""}{if
{duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}

The resulting merge document appears as follows:
Employee Project
Scott Cooper 4578j
86785x
543p
--- Page Break ---
Meng Phua 87x
89976m
--- Page Break ---
Kim Yoshida 7897r
857t
78974x
7868p

Neither of those solutions worked.

With Page Setup set Continous it still puts each item on a seperate page and
with Q212375 You need to have the code repeated "conditional statements
equal to the maximum number of projects for each employee", (above example).

We have some customers that buy only a few items, others buy 20 or 30. Had
one customer that bought more than 50 items.

Repeating that code more than 50 times seems "Not the way to go".

Would some one be so kind and point me in the proper direction to find this
answer?

Thank You for taking the time to read this post.

Andy

 

[Doug Robbins - Word MVP]

Use an Access report instead of mail merge.

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

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 Articles

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

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

But, I would use an Access Report to begin with.

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