Hi Jenny,

If you did not need to have the commas and/or the "and", it just a case of
four simple If...Then...Else statements.  The requirement for the commas and
or the "and" requires the use of what grows to become a very complex series
of nested If...Then...Else statements as there is a total of eleven
possibilties to be dealt with.  If you assign a value of 1 to NA for Test1,
3 to NA for Test2, 5 for NA for Test3 and 7 for NA for Test4 and then total
the values for the four test for each Member, you will get a number that is
unique for each possible combination of tests that are missed.  What I would
do is create a function in Access that used the Select Case Statement to
assign the required string to each of those unique values and then use that
function in a Query in Access to return the appropriate string for each
Member.

I started to create the necessary If..Then..Else field that you would need
in the mailmerge main document and got as far as the following before I came
to the conclusion that there was better way:

{?IF { MERGEFIELD Test1 }?= "NA" "Hb1c" "" }{ IF { MERGEFIELD Test 2 } =
"NA" {?IF { MERGEFIELD?Test1?}?=?"NA"?"Hb1c ,?EyeExam "?"" } " EyeExam " }
{?IF?{ ?MERGEFIELD?Test 3 }?=?"NA"?{?IF?{ MERGEFIELD?Test 2 }?=?"NA"?{
IF?{?MERGEFIELD?Test1 "Hb1c ,?EyeExam ,?LDL "?"" } " EyeExam ,?LDL " }
{?IF?{ MERGEFIELD?Test1 }?=?"NA"?"Hb1c LDL "?"" } " LDL " }{ IF?{
?MERGEFIELD?Test 4?} =?"NA"? {? IF? { ?MERGEFIELD?Test 3
IF?{?MERGEFIELD?Test 2 } =?"NA"?{ IF?{ MERGEFIELD?Test1 } =?"NA"?"Hb1c
,?EyeExam LDL and Micro "?"" } " EyeExam ,?LDL ?and?Micro "?"" }?" LDL
and?Micro " }?"Micro " }

The above is far from complete.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP