[MelissaM]

I am doing a label mail merge and have some blank address 2 lines and when I
print the label there is a blank space that I would like to get rid of. I
know there was a way in the old mail merge versions, but I can't seem to find
it in 2007.

[Doug Robbins - Word MVP]

Use an If...then...Else field construction in the mail merge main document

{ IF { MERGEFIELD Address2 } "" "{ MERGEFIELD Address2 }¶
{ MERGEFIELD Address3 }" "{ MERGEFIELD Address3 }" }

where you press the enter key where the pilcrow (¶) is located in the above
and you use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle off their display

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"MelissaM" wrote in message
...
I am doing a label mail merge and have some blank address 2 lines and when
I
print the label there is a blank space that I would like to get rid of. I
know there was a way in the old mail merge versions, but I can't seem to
find
it in 2007.