[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.

[Doug Robbins - Word MVP]

Use the following field construction where you use Ctrl+F9 to insert each
pair of Field Delimiters { }

{ IF { MERGEFIELD "Right Ear" } = "Pass" { IF { MERGEFIELD "Left Ear" } =
"Pass" "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" }
"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" }

Or, in the check box example, you could use the following field construction
in place of the first checkbox

{ IF { MERGEFIELD "Right Ear" } = "Pass" { IF { MERGEFIELD "Left Ear" } =
"Pass" [wingdings253] [wingdings168] } [windings168] }

and for the second use

{ IF { MERGEFIELD "Right Ear" } = "Pass" { IF { MERGEFIELD "Left Ear" } =
"Pass" [wingdings168] [wingdings253] } [windings253] }

where in place of the [wingdings168] and [wingdings253] you insert those
symbols via the Insert Symbols dialog.

Use Alt+f9 to toggle off the display of field codes.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

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