View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default using word 2007 suppress blank line when merge field is empty

Use an If...then...Else field construction

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD City }, { MERGEFIELD State }
{ MERGEFIELD Zip }" "{ MERGEFIELD Address2 }[Enter]"{ MERGEFIELD City }, {
MERGEFIELD State } { MERGEFIELD Zip }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display. Insert a carriage return in the field
construction in place of the [Enter]

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

"Shelly" wrote in message
...
Eg.
Not all records have an address2, need to skip blank line when this
happens.