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]
|