Help! I'm hoping that someone can point me to a VB script that will do a fairly simple task.

I have a Microsoft Access table that lists the full directory path for a number of files.

I am looking for a script that will create a new email message in Outlook that attaches each of the files listed in the table. The user will then input the recipient and subject, and can send the email from Outlook.

Any help would be greatly appreciated! Thanks in advance.