Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andy
 
Posts: n/a
Default MSAccess: Multiple Items On One Page

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


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default MSAccess: Multiple Items On One Page

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/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default...b;en-us;302665

http://support.microsoft.com/default...b;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

"Andy" wrote in message
...
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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with starting page numbering on page 3 rkbristol Page Layout 8 December 9th 05 12:25 AM
Multiple page TIFF file sent to Word Kemp Microsoft Word Help 1 November 5th 05 10:58 PM
watermark to only one page of a multiple page doc ATMYWITSEND Microsoft Word Help 1 September 22nd 05 05:11 PM
Page Numbers Print { PAGE } in Footer in WORD even after ALT + F9 Brent Microsoft Word Help 3 June 2nd 05 05:35 PM
Odd page section break Jenny Page Layout 5 December 15th 04 09:05 AM


All times are GMT +1. The time now is 02:36 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"