Title: Re: MagicMerge: Use only TLIs in a single Folder?
Post by Admin on 12/15/08 at 19:16:29
rb wrote: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.aspx> |
|
[edit]btw,
See MM built-in instructions for more
& also .doc file in MM thread.
[/edit]
|