Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Merge Logic Functions
Word 2007 Windows XP Home.
Recipient List Merged Output Desired First Name M First Name F Surname Jim Fir Jim Fir Joan Beech Joan Beech Pine Pine Paul Dianne Oak Paul and Dianne Oak Basically want IF {First Name M} AND {First Name F} ARE not blank then PRINT {{First Name M} and {First Name F}} ELSE PRINT {First Name M}{ First Name F} Have tried to work with the IF..THEN..ELSE "rule" including nesting IFs but no luck. Any solutions? |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Merge Logic Functions
Hi joe925c,
You could code your field as: {IF{IF{MERGEFIELD First_Name_M} "" 1 0}+{IF{MERGEFIELD First_Name_F} "" 1 0}= 2 "{MERGEFIELD First_Name_M} and {MERGEFIELD First_Name_F} "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [MVP - Microsoft Word] "joe925c" wrote in message ... Word 2007 Windows XP Home. Recipient List Merged Output Desired First Name M First Name F Surname Jim Fir Jim Fir Joan Beech Joan Beech Pine Pine Paul Dianne Oak Paul and Dianne Oak Basically want IF {First Name M} AND {First Name F} ARE not blank then PRINT {{First Name M} and {First Name F}} ELSE PRINT {First Name M}{ First Name F} Have tried to work with the IF..THEN..ELSE "rule" including nesting IFs but no luck. Any solutions? |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Merge Logic Functions
macropod,
Thanks for your response. Where can I find all the logic functions available? I used help and spent some time online at the Microsoft help series and even have the "Microsoft Office 2007 Bible" and no mention of the logic functions that I could find. I gather that you put the DO and ElSE data in quotes. I had thought that you only did that if the data was pure text. Makes sense or would be unable to determine the two strings. In this regard, below is the last series of data from your suggested solution. First_Name_F} "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"} Is there a missing quote mark after the First_Name_F}? That point would be the end of the DO string. "macropod" wrote: Hi joe925c, You could code your field as: {IF{IF{MERGEFIELD First_Name_M} "" 1 0}+{IF{MERGEFIELD First_Name_F} "" 1 0}= 2 "{MERGEFIELD First_Name_M} and {MERGEFIELD First_Name_F} "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [MVP - Microsoft Word] "joe925c" wrote in message ... Word 2007 Windows XP Home. Recipient List Merged Output Desired First Name M First Name F Surname Jim Fir Jim Fir Joan Beech Joan Beech Pine Pine Paul Dianne Oak Paul and Dianne Oak Basically want IF {First Name M} AND {First Name F} ARE not blank then PRINT {{First Name M} and {First Name F}} ELSE PRINT {First Name M}{ First Name F} Have tried to work with the IF..THEN..ELSE "rule" including nesting IFs but no luck. Any solutions? |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Merge Logic Functions
Hi joe925c,
It seems a doub;e-quote got lost somewhere along the line. The coding should have been: {IF{IF{MERGEFIELD First_Name_M} "" 1 0}+{IF{MERGEFIELD First_Name_F} "" 1 0}= 2 "{MERGEFIELD First_Name_M} and {MERGEFIELD First_Name_F}" "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"} Alternatively, one could use: {MERGEFIELD First_Name_M}{IF{IF{MERGEFIELD First_Name_M} "" 1 0}+{IF{MERGEFIELD First_Name_F} "" 1 0}= 2 " and " ""}{MERGEFIELD First_Name_M} The logic in the IF test is something I developed myself. I can't recall anything from MS discussing anything similar. You'll see the above technique and a variety of other field manipulations demonstrated in my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "joe925c" wrote in message ... macropod, Thanks for your response. Where can I find all the logic functions available? I used help and spent some time online at the Microsoft help series and even have the "Microsoft Office 2007 Bible" and no mention of the logic functions that I could find. I gather that you put the DO and ElSE data in quotes. I had thought that you only did that if the data was pure text. Makes sense or would be unable to determine the two strings. In this regard, below is the last series of data from your suggested solution. First_Name_F} "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"} Is there a missing quote mark after the First_Name_F}? That point would be the end of the DO string. "macropod" wrote: Hi joe925c, You could code your field as: {IF{IF{MERGEFIELD First_Name_M} "" 1 0}+{IF{MERGEFIELD First_Name_F} "" 1 0}= 2 "{MERGEFIELD First_Name_M} and {MERGEFIELD First_Name_F} "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [MVP - Microsoft Word] "joe925c" wrote in message ... Word 2007 Windows XP Home. Recipient List Merged Output Desired First Name M First Name F Surname Jim Fir Jim Fir Joan Beech Joan Beech Pine Pine Paul Dianne Oak Paul and Dianne Oak Basically want IF {First Name M} AND {First Name F} ARE not blank then PRINT {{First Name M} and {First Name F}} ELSE PRINT {First Name M}{ First Name F} Have tried to work with the IF..THEN..ELSE "rule" including nesting IFs but no luck. Any solutions? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then Else with mail merge faulty logic? | Mailmerge | |||
Syntax for performing arithmetic functions on merge fields. | Mailmerge | |||
Go To [Page Number] Logic? | Formatting Long Documents | |||
Check Box Logic | Mailmerge | |||
Fuzzy logic matching in a DLL | Microsoft Word Help |