mail merge with 2 different last names to the same address

  • Thread starter mail merge 2 different last names
  • Start date
M

mail merge 2 different last names

I am trying to mail merge a document to several women who use their maiden
name and their husbands.

How can I make my mail merge letter look like:

Mr. James Smith and Ms. Janet Doe
123 Main Street
Anytown, VA 12345

Dear Jim and Jan,
 
G

Graham Mayor

What fields do you have in your data source that would identify the
partners?

Normally you would have something along the lines of spouse surname and
forename fields. You can then use conditional fields to place the correct
data eg

{IF {Mergefield LastName} <> {Mergefield Spouse_Lastname} "{Mergefield
Title} {Mergefield FirstName} and {Mergefield Spouse_Title} {Mergefield
Spouse_FirstName} {Mergefield Spouse_LastName}" "{Mergefield Title} and
{Mergefield SpouseTitle} {Mergefield FirstName} {Mergefield LastName}"}

If some of the recipients are single and have no partners then the second
part of the condition requires a further condition eg

{IF {Mergefield LastName} <> {Mergefield Spouse_Lastname} "{Mergefield
Title} {Mergefield FirstName} and {Mergefield Spouse_Title} {Mergefield
Spouse_FirstName} {Mergefield Spouse_LastName}" "{IF {Mergefield
Spouse_LastName} <> "" "{Mergefield Title} and {Mergefield SpouseTitle}
{Mergefield FirstName} {Mergefield LastName}" "{Mergefield Title}
{Mergefield FirstName} {Mergefield LastName}" }


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Top