Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
madrayakin madrayakin is offline
Junior Member
 
Posts: 3
Default Addressing letters when two people with different last names live at same address

I'm using Word 2003 and trying to set up a letter using mail merge. I am having trouble making it work when I need to send the letter to two people with different surnames living at the same address. I have managed to set up the address line of the document as follows:

{ MERGEFIELD Title \f " " }{ MERGEFIELD First_name \f " " }{ MERGEFIELD "Surname" \f " " }{ IF { MERGEFIELD M_2nd_Surname} "" "& " "" }{ MERGEFIELD "M_2nd_Forename" \f " " }{ MERGEFIELD "M_2nd_Surname" \f " " }

However, I am having difficulty with the greeting line of the document, I want it to be able to figure out the following:

If both names have title information available, then use Dear Mr. Jones and Ms. Smith
If there is only one person, and we know their title, it should just say Dear Mr. Jones
In all other cases, it should say Dear Sir/Madam

Please can anyone help?

Many thanks,
Naomi

Last edited by madrayakin : March 25th 10 at 02:36 PM
 
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
Addressing an envelope, the address appears double-spaced, why? Bruce Microsoft Word Help 1 December 2nd 08 09:14 PM
PUT NAMES OF PEOPLE WITH THE SAME ADDRESS IN THE SAME DOCUMENT C Mailmerge 4 May 11th 08 12:33 PM
Multiple pages of different letters to different people Jan Microsoft Word Help 3 June 20th 07 04:30 PM
Please send emails and names of one thousand people to my box Display their names also New Users 4 December 24th 05 03:58 PM
Requirement for address book contact for addressing an envelope? ajsandbergjr Microsoft Word Help 5 December 11th 04 11:53 PM


All times are GMT +1. The time now is 09:18 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"