View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Insert certain paragraphs based on fields in Excel database

If your paragraphs are quite simple you should be able to use IF fields,
e.g.

{ IF "{ MERGEFIELD letter }" = "L" "put the text of your liability paragraph
here" ""
}{ IF "{ MERGEFIELD letter }" = "C" "put the text of your C type paragraph
here" ""
}

etc.

Use ctrl-F9 to insert each pair of {}, and type everything else in the usual
way.

Peter Jamieson

"MarvInBoise" wrote in message
...
Need to choose certain paragraphs to be inserted in Word document with
mail
merge to an Excel file; the Excel file "letter" field can contain a
character
defining the paragraph to be inserted, e.g., L=Liability pagragraph; the
"letter field can contain LCWG; each letter designates a different
paragraph
be inserted.
--
Marv Lusk
Boise Corporation