E-mailing Reports

[CKelly55]

I have created a Db of Photographers for a Competition. The Table has Surname,Forename,e-mail fields and also fields for the images and their scores. I want to be able to create a report and send the report to the e-mail address. I can create a Query to generate the report but don't know how to send each report to the e-mail address supplied. I haven't put the e-mail addresses in my Outlook Contacts and don't really want to because I want to keep the competition separate from my normal Contact list. Can anybody help me please.....

 

[.Justin]

I would also like to know how to send an e-mail to the address that is stored in the table if this is possible...