Without writing a VB script, is there a way to do a conditional merge on data
setup in a table like the following:

Name          Session     Type
Jane Doe     Morning     Absent
Jane Doe     Morning     Consecutive Absence
Jane Doe     Morning     Failure
John Doe     Morning     Absent

The data will always, or can be always, sorted in this fashion.  Using the
Skip Record If, I can set it up so that I can eliminate records based on
Session and Type.  But is there a way where I can skip a record based on a
previous records data, Name?

For instance, with the data above, I have one letter that goes out for
Failure, and another letter for Absent and Consecutive.  If I use the built
in functions, I will get two letters for Jane Doe, one for Absent, another
for Consecutive Absence.  I only need one.

The original table needs to remain intact, so removing the duplicate from
the source really isn't an option.

Thanks in advance.
John Viall