Access’ SendObject and Email’s To: field

Is there any way to have the SendObject command look at a table for the To: field. I have user info in a table and i need to have either the macro or VBA code look at that table for the Name in the To: field. It’s code that runs without the user’s input and needs to stay automatic. We customize about 40 apps/databases for this purpose. Any help would be appreciated.