Soldato
- Joined
- 18 Oct 2002
- Posts
- 2,537
- Location
- Norfolk
Hi Guys,
I am trying to set up a mail merge and have an issue when there are two people with different names at the same address. At the moment is there is a Mr John Smith and a Mrs Joan Smythe the greeting field will add it as Mr and Mrs Smith, which is obviously incorrect.
I have found other people who have asked about this on other forums but the responses they have been given go beyond my technical ability to actually use them!
The text I have found is:
and I have added each mergefield manually using CTRL+F9 and it does produce a name, but I am not sure how to get it to add into the greeting line to give the result I want.
Can anyone help please?
I am trying to set up a mail merge and have an issue when there are two people with different names at the same address. At the moment is there is a Mr John Smith and a Mrs Joan Smythe the greeting field will add it as Mr and Mrs Smith, which is obviously incorrect.
I have found other people who have asked about this on other forums but the responses they have been given go beyond my technical ability to actually use them!
The text I have found is:
Code:
{ 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 } "}
and I have added each mergefield manually using CTRL+F9 and it does produce a name, but I am not sure how to get it to add into the greeting line to give the result I want.
Can anyone help please?
Last edited: