[jflowers]

I am using word 2003 to do a address labels using mail merge. My data source
is in an excel spread sheet. The problem is that some of the addresses
contain a 2nd line for apt# and some don't? when the merge is complete it
leaves blank lines if there is noothing in the field. How can I get the merge
to reconize that is a field is empty and does not need a space?

[Doug Robbins - Word MVP]

Use an If...then...Else field construction, using Ctrl+F9 to insert each
pair of field delimiters

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD Address1 }" "{ MERGEFIELD
Address1 }¶
{ MERGEFIELD Address2 }" }

where the ¶ appears in the above, press Enter or Shift +Enter

Use Alt+F9 to toggle off the display of the field codes.

--
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

"jflowers" wrote in message
...
I am using word 2003 to do a address labels using mail merge. My data
source
is in an excel spread sheet. The problem is that some of the addresses
contain a 2nd line for apt# and some don't? when the merge is complete it
leaves blank lines if there is noothing in the field. How can I get the
merge
to reconize that is a field is empty and does not need a space?