Mail Merge Label - Fields

[nick514]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel When I try to merge some mailing labels I have 2 address fields "address1" and "address2". I need both of these on the labels for those people who have information in "address2" but for people who don't have any information in that section I don't want a blank space. Is there anyway to fix this?

 

[Peter Jamieson]

Use nested IF fields that insert the data /and/ a paragraph mark if the
field is not blank, but insert nothing if the field is blank. Like this:
{ IF { MERGEFIELD field1 } <> ""
"{ MERGEFIELD field1 }
" "" }{ IF { MERGEFIELD field2 } <> ""
"{ MERGEFIELD field2 }
" "" }{ IF { MERGEFIELD field3 } <> ""
"{ MERGEFIELD field3 }
" "" }

etc.

All the {} have to be the special "field code braces" that you can
insert using cmd-F9 - or see the following link if that does not work
for you:

http://word.mvps.org/mac/fieldsinmacword.html

Peter Jamieson

http://tips.pjmsn.me.uk

 

[Maximzodal]

Use nested IF fields that insert the data /and/ a paragraph mark if the
field is not blank, but insert nothing if the field is blank. Like this:
{ IF { MERGEFIELD field1 } <> ""
"{ MERGEFIELD field1 }
" "" }{ IF { MERGEFIELD field2 } <> ""
"{ MERGEFIELD field2 }
" "" }{ IF { MERGEFIELD field3 } <> ""
"{ MERGEFIELD field3 }
" "" }

etc.

All the {} have to be the special "field code braces" that you can
insert using cmd-F9 - or see the following link if that does not work
for you:

http://word.mvps.org/mac/fieldsinmacword.html

Peter Jamieson

Thanks Peter! There have been occasions when I could have used this
information but never pursued it.

Max