Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mail merge 2 different last names
 
Posts: n/a
Default mail merge with 2 different last names to the same address

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,

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default mail merge with 2 different last names to the same address

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



mail merge 2 different last names wrote:
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,



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment [email protected] Mailmerge 24 January 15th 07 09:33 PM
How do I stop mail merge address block repeating fields twice? Dan Dare Mailmerge 1 February 2nd 06 06:33 PM
In mail merge labels the name and address starts again, why? Bruno Mailmerge 1 February 1st 06 04:57 AM
Address Line Format for Mail Merge Misha Mailmerge 1 August 2nd 05 04:52 AM
How do I add names to an existing mail merge address book created. 61934 Mailmerge 1 March 22nd 05 09:31 PM


All times are GMT +1. The time now is 01:29 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"