automatically send emails with attached distinct file - email merge - MS Access
Posted on 2008-06-23
Hi, I have an Access DB that contains a list of individuals (agents). I also have a folder that contains Excel Spreadsheets with a file name exactly the same as the agent name in the Access DB. What I'd like to do is to create a script that is attached to a button in the database that when clicked will grab each Excel file and automatically email it to the email address we have on file in the database. I've found some code that will send an email but having some problems figuring out how to automate the process. Any help is much appreciated. Thanks.