I don't know Access VBA. But if you know how to use SendObject once, you
just need to loop trough the result of your query and call the object once
in every loop.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Mon, 28 Apr 2008 00:43:00 -0700 schrieb Emma Hope:

Thanks. Can you give me some advice on how to go about this.