A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Addressing letters when two people with different last names live at same address



 
 
Thread Tools Display Modes
  #1  
Old March 25th, 2010, 03:31 PM posted to microsoft.public.word.mailmerge.fields
madrayakin
external usenet poster
 
Posts: 1
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




--
madrayakin
  #2  
Old March 30th, 2010, 11:23 AM posted to microsoft.public.word.mailmerge.fields
madrayakin[_2_]
external usenet poster
 
Posts: 1
Default Addressing letters when two people with different last names live at same address


Is anyone able to help me please? I'm sorry if I have not explained
myself very well

Naomi

madrayakin;463011 Wrote:
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





--
madrayakin
  #3  
Old March 30th, 2010, 02:55 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Addressing letters when two people with different last names live at same address

You don't seem to have sufficient title fields to address the situation
where there are two people involved. You only quote a title field for the
first party.
You would need separate title fields for each party to cover same sex people
living at the same address.

--

Graham Mayor - Word MVP

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



"madrayakin" wrote in message
...

Is anyone able to help me please? I'm sorry if I have not explained
myself very well

Naomi

madrayakin;463011 Wrote:
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





--
madrayakin



  #4  
Old March 30th, 2010, 03:57 PM posted to microsoft.public.word.mailmerge.fields
madrayakin[_3_]
external usenet poster
 
Posts: 1
Default Addressing letters when two people with different last names live at same address


Have worked this out myself in the end, so no need for any response




--
madrayakin
  #5  
Old March 30th, 2010, 05:01 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Addressing letters when two people with different last nameslive at same address

Let's suppose that you always have a first person, that you have the
following fields for the first person

Title
First_Name
Surname

and the following fields for the second person:

M_2nd_Title
M_2nd_Forename
M_2nd_Surname

and you can assume that a blank M_2nd_Surname
a. implies there is no second person
b. implies that M_2nd_Forename and M_2nd_Title are also blank

Then starting from this specification:

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


you could use a number of different approaches, e.g.

e.g.

Dear {
IF { MERGEFIELD Title } ""
"{ IF { MERGEFIELD M_2nd_Title } ""
"{ MERGEFIELD Title } { MERGEFIELD Surname
} and { MERGEFIELD M_2nd_Title } { MERGEFIELD M_2nd_Surname } }"
"{ IF { MERGEFIELD M_2nd_Surname } = ""
"{ MERGEFIELD Title } { MERGEFIELD Surname }"
"Sir/Madam"
}"
"
"Sir/Madam" }

As for the /address/, I would go along with Graham, but there is a
always a problem with shared addresses that even people with the same
surname are not necessarily in the way that, for example, "Mr and Mrs
Smith" would traditionally imply on the envelope, and might not be
related at all. But perhaps the way your data is collected and entered
takes care of that kind of difficulty.

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 11:23, madrayakin wrote:
Is anyone able to help me please? I'm sorry if I have not explained
myself very well

Naomi

madrayakin;463011 Wrote:
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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.