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