View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Using Mail Merge with Excel Data

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 {} need to be the special field brace pairs that you can
insert using ctrl-F9

Peter Jamieson

http://tips.pjmsn.me.uk

On 12/04/2010 15:58, Renegade wrote:
In Word XP, if some of the data fields have blanks (i.e. Address 1 but
Address 2 does not include anything), how do I configure the Mail Merge
instructions to disregard the blank fields without leaving a blank line in
its place?