Send Object - sending queries to specific Recipient

[SendObject - Macros]

Case scenerio:
-15 recipient (all emails are entered into a table)
-1 master history table
-1 query that ties the two table together

How would SendObject automatically sends the query ( in excel format) to
each of the recipient base on the email table rather than creating 15 queries
with 15 different macros?

Please let me know what you know or let me know if what I'm trying to do in
impossible......

Thanks in Advance,
Sean