How skip empty data field to create address in Word envelope

[DaleB]

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

 

[Graham Mayor]

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


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


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

 

[DaleB]

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.