Mail merge

[Larry]

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

 

[David McRitchie]

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.