SendTo function with a mailing list (1 Viewer)

[Fasopus]

SendObject function with a mailing list

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?

 

[pbaldy]

This should get you started:

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