I currently have an access query which will produce a list
of managers and employees they manage.  Sometimes a
manager may have one employee they manage or they may have
50.  I would like to create a mail merge where I can send
ONE email to each manager and a list of their employees.  
I use the manager's employee number as my field to email
the list to the correct manager.  However I cannot get the
mail merge to work how I need it to.  It either sends x
emails to the manager with x employees or sends one email
to the last person on the list with all the entries.

Is there some way I cen get the mail merge to read the
first column of my access query and then send a list of
all entires in that correspond to that manager?

I hope that makes sense... and feedback would be greatly
appreciated.