Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Agreed - though no space will produce the error.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Graham, Only the space after the operand is required - as shown in my post. Spaces before & after won't do any harm, though. "Graham Mayor" wrote in message ... Put a space either side of thus {IF 3 0 "True text" "False text"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 8Leonie8 wrote: Yes I did. I even followed the help Peter Jamieson has given in the topic titled "=AND" He says: then use right-click and toggle field codes to see the result of that part of the whole construct to see if you can detect which part is causing the problem. If I click toggle field code(I'm not sure if that's the correct English word for this option, I'm translating from the Dutch version of Word), it seems every part of the function is working. When I click toggle field code for the different mergefields first I get: { IF { =1+1+1}0 "True text" "False text"} If I go a step further and click toggle field code for {=1+1+1} I get: { IF 30 "True text" "False text"}. So far so good, you'd say, but when I click toggle field code for the last step I get: Error! Unknown operator in precondition Hope I've explained my actions in an understandable way, otherwise let me know. gr leonie "Graham Mayor" wrote: Did you enter all the brackets with CTRL+F9? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 8Leonie8 wrote: Hi there, I'm trying to use the OR function in my Word 2003 document (dutch version), but I can't get it to work. I get the following reaction when merging to a new document: Error! Unknown operator in precondition Does anyone have an idea why this doesn't work?? "macropod" wrote: Hi Rhiannon, You can build a multiple AND test this way: {IF{={IF{MERGEFIELD 1}= "Y" 1 0}*{IF{MERGEFIELD 2} 2 1 0}*{IF{MERGEFIELD 3}= "text" 1 0}}= 1 "True Text" "False Text"} Similarly, you can build a multiple OR test this way: {IF{={IF{MERGEFIELD 1}= "Y" 1 0}+{IF{MERGEFIELD 2} 2 1 0}+{IF{MERGEFIELD 3}= "text" 1 0}} 0 "True Text" "False Text"} -- Cheers macropod [Microsoft MVP - Word] "Rhiannon" wrote in message ... I'm working in Word 2007. I have a list of mergefields (anywhere between 3 and 7 depending) that I would like to test the values of - if all of them come back true, return one block of text, else return another block of text. It works fine when I try and compare the values of two mergefields: {IF { = AND ( { COMPARE {Mergefield 1} = "Y"}, {COMPARE {mergefield 2} 2 } ) } = 1 "true" "false" } but as soon as I try and compare the values of three or more mergefields: {IF { = AND ( { COMPARE {Mergefield 1} = "Y"}, {COMPARE {mergefield 2} 2 }, { COMPARE {mergefield 3" = "text" } ) } = 1 "true" "false" } it breaks. Is there a way to expand beyond two comparisons, using either the =AND or the =OR formulas? I'd rather not start nesting piles of these if I can help it. Thanks muchly!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert date field into merge-query options-compare to | Microsoft Word Help | |||
MailMerge Through VBA Printing Actual Field Names NOT Field Values | Mailmerge | |||
How do I compare later/earlier dates in a mail merge IF field? | Mailmerge | |||
How do I compare later/earlier dates in a mail merge IF field? | Mailmerge | |||
percentage values in a merge field ? | Mailmerge |