So what I need to do with my database is make it so that with the push of a button a report is generated and emailed. I figured a macro would do and the SendObject macro seems to be what I am looking for. However I want to have it Send to every email located in a table titled mailing list. How would I go about using SendObject in this manner? Is this even the best way?

This should get you started:

http://www.granite.ab.ca/access/email/recordsetloop.htm