Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
mail merge - different last names?
I have my addresses in an Excel file. I've matched the fields for Title,
First, Last, Spouse Title, Spouse First, and Spouse Last - so far so good. But for couples with different last names, my label does not read (as I would expect): Mr. John Doe and Mrs. Jane Smith I just get: Mr. and Mrs. John Doe Does anyone know how to make it do the former, but only in the case where the couple has different last names? Thanks, Robb |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
mail merge - different last names?
For this you need a conditional field construction that will cover all
eventualities thus: { IF{ Mergefield Last } { Mergefield "Spouse Last" } "{ IF{ Mergefield "Spouse Last" } "" "{ Mergefield Title } { Mergefield First} { Mergefield Last } & { Mergefield "Spouse Title" } { Mergefield "Spouse First" } { Mergefield "Spouse Last" }" "{ Mergefield Title } { Mergefield First} { Mergefield Last }" }" "{ Mergefield Title } & { Mergefield "Spouse Title" } { Mergefield First} { Mergefield Last } "} ie If last name is not equal to spouse last name and if spouse last name exists enter Mr. John Doe and Mrs. Jane Smith if the spouse last name doesn't exist enter Mr. John Doe otherwise enter Mr. and Mrs. John Doe All the fields are inserted by hand using CTRL+F9 for each pair of brackets. Watch out for spelling errors and spaces and make sure your field names are correct. If there are spaces in the field names you will need quotes around them. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Robb wrote: I have my addresses in an Excel file. I've matched the fields for Title, First, Last, Spouse Title, Spouse First, and Spouse Last - so far so good. But for couples with different last names, my label does not read (as I would expect): Mr. John Doe and Mrs. Jane Smith I just get: Mr. and Mrs. John Doe Does anyone know how to make it do the former, but only in the case where the couple has different last names? Thanks, Robb |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge doesn't recognize two-word names from Outlook | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
How do I add names to an existing mail merge address book created. | Mailmerge | |||
How do I mail merge to have different names on the main docume | Mailmerge | |||
Step By step mail merge 287 names on labels | New Users |