Quote from rb on 12/15/08 at 16:25:02:
If the folder I want to show is "folderX", do I simply add this field to the template? I guess that I need need something like:
If {folderX}==0 then "Skip this Merge Page" (is each merged page a record?).
What is the correct syntax?
nope.
checkout the MS Word documentation for syntax, etc.
Quote:WD2000: How to Merge Conditional Number of Records to Same Page
View products that this article applies to.
This article was previously published under Q212375
Expand all | Collapse all
SUMMARY
In Microsoft Word, you can merge a conditional number of records to the same pa...
In Microsoft Word, you can merge a conditional number of records to the same page.
MORE INFORMATION
To merge a conditional number of records to the same page, use a combination of...
To merge a conditional number of records to the same page, use a combination of SET, IF, and NEXTIF fields. For example, you can use this method to merge all records with the same name to one page in the merge and create a new page in the merge when a new name is encountered in the data file.
The following example uses a data file with employee names (Employee) and projects they are working on (Projects). The Check field is used in the data file to mark the last record of a particular name.
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}"}
Where "P" represents a paragraph mark that pushes the next project to a new line, and "t" represents a tab character that aligns the next project under the previous 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
APPLIES TO
* Microsoft Word 2000 Standard Edition
Back to the top
Keywords:
kbinfo kbmerge kbfield KB212375
source:
<
http://support.microsoft.com/kb/212375> or, Cf.
Quote:Mail merge question about SKIPIF and NEXTIF - blingting
21-Aug-07 10:28:06
Hello,
How can we use mail merge in Microsoft Word in the following scenario:
There is a table of Data:
Condition Name Description
```````````` ````````` ```````````````
0 Name1 Description1
1 Name2 Description2
1 Name3 Description3
0 Name4 Description4
1 Name5 Description5
I want to use the records of the above data set in a document.
If the value of the Condition column in a given row is 0, then that row of
record will be skipped. If the Condition is 1, then it will be recorded. How
do we set it up within mail merge of Ms Word?
Please ask if you need more explaination.
Thanks.
button
Mail merge question about SKIPIF and NEXTIF - Peter Jamieson
21-Aug-07 10:42:50
If you just need to process all records in the data source where Condition =
1, then you should be able to use the query options to do it. How to do that
depends on the version of Word, but in Word 2002 and later you need to get
to the Mail Merge Recipients dialog (which lists the data records), then
select the drop-down at the top of the COndition column - if there are only
two or three different values in the column you should see them listed, and
you can select "1". Otherwise, you may need to select the Advanced... option
in the dropdown and fill in the "Query Options" form that appears. In WOrd
2000 and earlier, you can get tot the Query Options form via the Mail Merge
Helper and fill it in. Although that should work in theory, sometimes the
query options dialog does not work properly, with some types of data source.
The other option would be to use a { SKIPIF } field at the top of the mail
merge main document. In this case, you could try
{ SKIPIF { MERGEFIELD Condition } = 0 }
or possibly
{ SKIPIF "{ MERGEFIELD Condition }" = "0" }
ALl the {} need to be the special field code braces that you can insert
using ctrl-F9
You can't always use SKIPIF successfully - for example, with a label merge,
you would need multiple SKIPIFs, one for each label, and the trouble then is
that the SKIPIF cancels the merge of the current copy of the document, i.e.
loses all previous labels on the current page.
--
Peter Jamieson
http://tips.pjmsn.me.uk source:
<
http://www.eggheadcafe.com/software/aspnet/30587897/mail-merge-question-about.as
px> Edited: btw,
See MM built-in instructions for more
& also .doc file in MM thread.