You will not achieve the results you require with the addressblock field.
Use the individual fields - see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
As for the spouse issue, use a conditional field
eg something along the lines of
{ IF{ Mergefield First2 } "" "{ IF{ Mergefield Last1 } { Mergefield
Last 2 } "{ Mergefield First1} { Mergefield Last1 } and { Mergefield
First2 } { Mergefield Last2}" "{ Mergefield First1 } and { Mergefield
First2 } and { Mergefield Last1 }"}" "{ Mergefield First1 } { Mergefield
Last1 }" }
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
djackola wrote:
I have a spreadsheet with the following column headings
Last1 First1 Last2 First2 Address City State Zip
Smith John Jones Mary 123 Main St Anywhere NC 27777
I have the Block Address selected which would make the label
John Smith and Mary Jones
123 Main St
Anywhere, NC 27777
These labels as well as John and Mary Smith (when spouse has same
last name) are coming out fine. The problem is that if any entry on
my Excel list is for John Smith ONLY, the label is coming out "The
Smith Family".
How can I make it come out as John Smith on my Word label?
thanks...
Dee