Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with starting page numbering on page 3 | Page Layout | |||
Multiple page TIFF file sent to Word | Microsoft Word Help | |||
watermark to only one page of a multiple page doc | Microsoft Word Help | |||
Page Numbers Print { PAGE } in Footer in WORD even after ALT + F9 | Microsoft Word Help | |||
Odd page section break | Page Layout |