![]() |
|
|
|
#1
|
||||
|
||||
|
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 |