strange formatting results

[sloe]

I'm creating mailing list lables in Word 2002. I am
creating the lables from an excel page with the name,
address, etc..., of the people i want to send to. I have
separate catagories on this list for their name, their
last name, their spouse's name, and their spouse's last
name (if they have a differnt one)

I have people on this list who:
1. have no spouse
2. have a spouse with the same last name
3. and, who have a spouse with a differnt last name

The problem is when i select a format for the name part, i
can't get it to accept all these differnt possiblities.
The closest i seem to be able to get is when i
select "josh randal and cynthia smith" When i do that i
get 2 and 3, but for people that have no spouse, it
says "The smith family"

help

sloe

 

[Graham Mayor]

This should be easy enough with conditional fields, but you need to post
what name fields you have and what type of data they contain in order to
work out the best way to handle it.
List a few sample records (with false data) and the fieldnames.

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

If you have the mailmerge main document active and you press Alt+F9, the
field codes will be revealed.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Graham Mayor]

You need to create the following nested field which should all be on one
line - allowing the line to wrap naturally. Note the positions of the speech
marks "" which are important. The field boundaries are inserted by hand with
CTRL+F9.

{IF { Mergefield Spouse} <> "" "{IF {Mergefeield lastname} <> {Mergefield
spouselastname} "{Mergefield name} {Mergefield lastname } and {Mergefield
spouse} {Mergefield spouselastname}" "{Mergefield name } and {Mergefield
spouse} {Mergefield lastname }" }" "The {Mergefield lastname } family" }


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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>