I have a Folder that has around 300 Excel Workbooks. I also have a table in access that has the email addresses for every workbook that should be sent. Please help me develop a code that will attach the Excel File to the specific email. Ex..
Excel Workbook Name: OZ3.XLS
Access Table :
Field One :OZ3
Field Two: [email protected]

Thanks a million