VBA in Access, send email using values in a table

Hi there,

I am currently trying to setup an automated email facility which sends an email to a designated distribution list (this is contained in a table called: tblMailShotAddresses, with the emails stored under the EMAIL column). I have the email sending with an attachment, however I cannot seem to figure out how to get my code to load all of the values in the EMAIL column into an array and then send an email to eachof these????

Can anyone help?

Cheers

Hi

Don't worry about my query I managed to get it working using the DCount and DLookup functions.

Cheers