can you insert a paragraph into a mail merge letter

M

mnm_nut

I have a form letter set up as a mail merge and one of the mail merge fields
is a code that I want to use to select an entire "paragraph" to be used in
the letter. Say there are 10 codes to determine 10 different choices of a
paragraph to merge into my standard letter.... any idea if this is possible -
I'm using Excel (2000) as the data source for the names and addresses and the
"code" - where would I put the choices of the "paragraphs" that I would like
to "merge" into my letter. The CODE determines what kind of "thank you gift"
the people should receive and I want to use one standard letter with a
different paragraph telling them of their gift..... thanks
 
G

GTS

mnm_nut said:
I have a form letter set up as a mail merge and one of the mail merge fields
is a code that I want to use to select an entire "paragraph" to be used in
the letter. Say there are 10 codes to determine 10 different choices of a
paragraph to merge into my standard letter.... any idea if this is possible -
I'm using Excel (2000) as the data source for the names and addresses and the
"code" - where would I put the choices of the "paragraphs" that I would like
to "merge" into my letter. The CODE determines what kind of "thank you gift"
the people should receive and I want to use one standard letter with a
different paragraph telling them of their gift..... thanks

You would just use embedded IF statements.
{IF CODE = "CODE TYPE 1" "PARAGRAPH ONE GOES HERE" "{IF CODE ="CODE TYPE 2"
"PARAGRAPH TWO GOES HERE" ""}""
Indeed, you can put complete letters in IF statements, not just paragraphs,
so the whole document could be different for each code type...
Graham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top