#1
|
|||
|
|||
Mail Merge Directory - Combining fields
For a school directory, Iwant to print the student's name in one column and parent's names in another. Fields are Parent1 and Parent2.
I want to print both if both are populated with the word "and" between them, and only Parent1 if Parent2 is blank. In other words: If Parent2 is blank, print Parent1 else print "Parent1 and Parent2" Example: Student Parent John Smith Chris and Debbie Tina Jones Barbara I can't figure out how to print both parent names if they are both populated in the else clause. Just listing them {MERGEFIELD Parent1} {MERGEFIELD Parent2} does not work -- it only prints Parent1. Can anyone give the proper syntex? |
#2
|
||||
|
||||
Hi Officegirl,
Basically, the field construction would be something like: {MERGEFIELD Student _First_Name } {MERGEFIELD Student _Last_Name } {IF{MERGEFIELD Parent1_Last_Name} = {MERGEFIELD Parent2_Last_Name} "{MERGEFIELD Parent1_First_Name} & {MERGEFIELD Parent2_First_Name} {MERGEFIELD Parent1_Last_Name}" "{MERGEFIELD Parent1_First_Name} {MERGEFIELD Parent1_Last_Name}{IF{MERGEFIELD Parent1_Last_Name} <> "" " & {MERGEFIELD Parent2_First_Name} {MERGEFIELD Parent2_Last_Name}"}} or: «Student _First_Name» «Student _Last_Name» {IF«Parent1_Last_Name» = «Parent2_Last_Name» "«Parent1_First_Name» & «Parent2_First_Name» «Parent1_Last_Name»" "«Parent1_First_Name» «Parent1_Last_Name»{IF«Parent1_Last_Name» <> "" " & «Parent2_First_Name» « Parent2_Last_Name»"}} Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. Also, the test requires - at a minimum - that there be separate fields for the parents' last names.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
directory, ifthenelse, mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Directory Mail Merge with table layout | 3N1GM4 | Mail Merge | 11 | 06-03-2014 09:54 PM |
Mail Merge only produces 15 fields fm 22 | Galceran | Mail Merge | 2 | 02-10-2013 05:47 PM |
Detecting Page Breaks in Mail Merge Directory | TimK9VB | Mail Merge | 6 | 11-20-2012 01:52 PM |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
Paragraph Breaks In Mail Merge Fields | SamuelT | Mail Merge | 0 | 09-25-2008 06:38 AM |