strange formatting results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sloe - 03 Mar 2004 21:45 GMT

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

Reply to this Message

Graham Mayor - 04 Mar 2004 06:18 GMT

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.

Signature

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

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

> I'm creating mailing list lables in Word 2002. I am
> creating the lables from an excel page with the name,
[quoted text clipped - 18 lines]
>
> sloe

Reply to this Message

sam - 05 Mar 2004 17:47 GMT

In the excel document, i have:
name lastName spouse spouseLastName street ...

if i have the following:
bob smith jane (blank)
i get:
bob and jane smith (which is correct)

if i have:
bob smith jane jenkins
i get:
bob smith and jane jenkins (which is also correct)

but, if i have:
bob smith (blank) (blank)
i get:
the smith family (?!)

tell me about these conditional fields.
sam

> 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.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 05 Mar 2004 22:38 GMT

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

Signature

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

> In the excel document, i have:
> name lastName spouse spouseLastName street ...
[quoted text clipped - 21 lines]
>> work out the best way to handle it.
>> List a few sample records (with false data) and the fieldnames.

Reply to this Message

Graham Mayor - 06 Mar 2004 06:25 GMT

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" }

Signature

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

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

> In the excel document, i have:
> name lastName spouse spouseLastName street ...
[quoted text clipped - 21 lines]
>> order to work out the best way to handle it.
>> List a few sample records (with false data) and the fieldnames.

Reply to this Message