I have to do a mail merge using a name and address spreadsheet. The problem
is I need to select different sentences to insert into the Word doc using a
code that I'm going to attach to each name and address. Code A calls for one
sentence, code B calls for another, etc. Some names have several codes so
they will require several sentences. Some names have no codes.

How can I set this up so if a name has a code or several codes or no codes,
specific sentences will be selected and printed?

Ideas, please.

Thanks,

Larry

Hi Larry,
You have to have everything in the worksheet, you would simply include
another column with the sentence of your choice, included with a
simple IF Worksheet Formula
use the fill handle to fill the formula down.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
for information on use of Mail Merge to print labels, see
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
if you are printing a letter you might use one of the other links there.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Larry" <elderlarryathotmaildotcom wrote in message ...
I have to do a mail merge using a name and address spreadsheet. The problem
is I need to select different sentences to insert into the Word doc using a
code that I'm going to attach to each name and address. Code A calls for one
sentence, code B calls for another, etc. Some names have several codes so
they will require several sentences. Some names have no codes.

How can I set this up so if a name has a code or several codes or no codes,
specific sentences will be selected and printed?

Ideas, please.

Thanks,

Larry