Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Spouses with different last names
Can't figure out how to direct Word to print labels in the following format:
Mr. and Mrs. John Smith (when both spouses have same last name) vs. Mr. John Smith Ms. Kathy Taylor (when spouses have different last names. ) Guessing I need an If statement, but can't figure it out..... My data is set up with seperate fields for Courtesy Title, first name, last name for the contact and spouse seperately, and an "extra" courtesy title field for "Mr. and Mrs." Please help! and thanks in advance -- Karen |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Spouses with different last names
You need something like
{ IF { Mergefield SpouseLastName } "" "{ IF{ Mergefield LastName } { Mergefield SpouseLastName } "{ Mergefield CourtesyTitle } { Mergefield FirstName } { Mergefield LastName } & { Mergefield SpouseCourtesyTitle } { Mergefield SpouseFirst Name} { Mergefield SpouseLastName }" "{ Mergefield CourtesyTitle } & { Mergefield SpouseCourtesyTitle } { Mergefield LastName }" }" "{ Mergefield CourtesyTitle } { Mergefield FirstName } { Mergefield LastName}" } You would need firstname lastname and courtesytitle for both principal and spouse. The Mr & Mrs field is superfluous The above should cater for single people as well as married people and cohabitees.Change the field names as appropriate. Each pair of curly brackets is inserted with CTRL+F9 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Karen wrote: Can't figure out how to direct Word to print labels in the following format: Mr. and Mrs. John Smith (when both spouses have same last name) vs. Mr. John Smith Ms. Kathy Taylor (when spouses have different last names. ) Guessing I need an If statement, but can't figure it out..... My data is set up with seperate fields for Courtesy Title, first name, last name for the contact and spouse seperately, and an "extra" courtesy title field for "Mr. and Mrs." Please help! and thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set "List Font names in their names" property in Word 2007 | Microsoft Word Help | |||
how to alphabet names Last names | Microsoft Word Help | |||
Mail merging spouses | Microsoft Word Help | |||
ABC order last names on list where last names are last | Microsoft Word Help | |||
Merge Several Names on One Doc Page, Then Different Names on Next | Mailmerge |