I'm trying to do mail merge of envelopes in WORD using EXCEL spreadsheet as
database source of addressees' information. (I'm using Office Standard
Edition 2003) For some records, certain data fields used to "write"
addressee's information are empty, for example, Address 2. How do I merge
such that in those cases the envelope prints as follows:
Name
Address 1
City, State Zip
as opposed to leaving blank line between Address 1 and City, State Zip

Use the individual fields as follows

{Mergefield Name}
{Mergefield Address 1}{IF {Mergefield Address2} "" "
{Mergefield Address2}
{Mergefield City}, {Mergefield State} {Mergefield Zip}

If necessary you can add similar conditions to the other fields

See also http://www.gmayor.com/formatting_word_fields.htm and the Excel data
section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


DaleB wrote:
I'm trying to do mail merge of envelopes in WORD using EXCEL
spreadsheet as database source of addressees' information. (I'm
using Office Standard Edition 2003) For some records, certain data
fields used to "write" addressee's information are empty, for
example, Address 2. How do I merge such that in those cases the
envelope prints as follows:
Name
Address 1
City, State Zip
as opposed to leaving blank line between Address 1 and City, State Zip

Thank you Graham. I still couldn't figure this out per your suggestions (I'm
not dumb; I'm clearly not as advanced as you, but I do know a thing or two.
I knew how to do this the "old way"). I eventually went to your website and
learned how to re-configure WORD to allow application of old way. Maybe I'm
old fashion, but I wish Microsoft would stop changing things that worked well
enough before.
Once again, thanks.

"Graham Mayor" wrote:

Use the individual fields as follows

{Mergefield Name}
{Mergefield Address 1}{IF {Mergefield Address2} "" "
{Mergefield Address2}
{Mergefield City}, {Mergefield State} {Mergefield Zip}

If necessary you can add similar conditions to the other fields

See also http://www.gmayor.com/formatting_word_fields.htm and the Excel data
section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


DaleB wrote:
I'm trying to do mail merge of envelopes in WORD using EXCEL
spreadsheet as database source of addressees' information. (I'm
using Office Standard Edition 2003) For some records, certain data
fields used to "write" addressee's information are empty, for
example, Address 2. How do I merge such that in those cases the
envelope prints as follows:
Name
Address 1
City, State Zip
as opposed to leaving blank line between Address 1 and City, State Zip