How do I stop "and family" from printing when there is only 1 name

[Guest]

We must print up thousand of labels each month from an Excel file, some names
have a spouse, some do not. Those that do not are printed "and family" Not
good for a business label. Presently we are replacing all the blank spouse
names in the Excel file with "none". Then when Word does the mail merge, we
find & replace to remove all of the " and none ". It works, but having to
mess with the Excel file each time is a pain . The find & replace in Word
only takes a minute, so that part really isn't a huge deal. But pasting
"none" into about 1800 blank spouse names is. Does any one have a better
solution?
Thanks
Kate

 

[Joe McGuire]

You have figured out how to solve your Word problem using Find and Replace,.
Although somebody here might be able to offer some help, you might want to
post your Excel question (how to do something like Find and Replace on your
spreadsheet) on the Excel board.

 

[Graham Mayor]

You need to setup the mail merge to take account of what you have. If the
Spouse field is empty or contains the word none you can conditionally insert
that or other information in the label format. eg

{ IF { MERGEFIELD Spouse } = "" " and family" "{ IF{ MERGEFIELD Spouse
\*upper } = "NONE" " and family" " and { MERGEFIELD Spouse }" }" }

See also http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>