[Shannan]

I have no idea if this is possible, but here's what i would like to do:
I have a mail merge letter and part of the letter is the following

 Indicated normal hearing for both ears
 Indicated the need for a more thorough hearing evaluation. The student
has been referred to the Public Health Unit Audiology program for a complete
evaluation.

I have columns in my data source spreadsheet for "Right Ear" and for "Left
Ear". Each of these either gets filled out with "Pass" or "Fail". I would
like to set this up so that it someway marks the appropriate line (i don't
think there's a way to make it check the box, which would be preferrable)
based on what is written in these columns. So it should mark the first line
if Right Ear and Left Ear = Pass and it should mark the second line if either
Right Ear or Left Ear = Fail.

Alternately if there is a formula i could use to have it just show
"Indicated normal hearing for both ears" if Right Ear and Left Ear = Pass and
show "Indicated the need for a more thorough hearing evaluation. The student
has been referred to the Public Health Unit Audiology program for a complete
evaluation" if either Right Ear or Left Ear = fail, that would work too.