Reply
 
Thread Tools Display Modes
  #1   Report Post  
mnm_nut
 
Posts: n/a
Default can you insert a paragraph into a mail merge letter

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
  #2   Report Post  
GTS
 
Posts: n/a
Default


"mnm_nut" wrote in message
...
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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 16th 05 12:38 AM
Insert excel data into word via mail merge Jane Mailmerge 1 December 22nd 04 11:53 PM
No options for Insert Mail Merge Fields sweir3 Mailmerge 1 December 20th 04 11:39 PM


All times are GMT +1. The time now is 04:14 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"