Hi all,

Was wondering if it is possible to actually code the script such that it will actually take in a file name located in a folder and loop through MS access table to determine what emails are kept in each filename. It will then take the email addresses out, compose a mail and attach the file onto the mail and send out to the respective recipients.

For example,

FileName-----------Email Address
A1-----------------wkevin@hotmail.com, betts_gash@gmx.com
A2-----------------kurthing@gmail.com

I'm clueless on where to start, do guide me. Thanks!