I am looking to do something that is very similar to a
Group By function in a database, or a pivot table in
Excel.

I have a table that looks something like:

EventID   First   Last
1         michel  girard
1         john    doe
2         jane    smith
3         tom     smith

What I want is on each page, create a print merge that
just lists out all the first and last names for each
unique event ID.

I can do this in Access or Excel.  The reason I don't use
those apps because I am really going to do a print merge
to email and automatically email resutls.  I can't do
that with Access or Excel.

Thanks
Michel