Emailing data with Access
Hey there!
For my work I keep track of things in an Access database. I receive data, edit and regroup it and after that distribute it to other people. Every month I have to mail exported *.txt files to a group of people. And since not everybody gets the same data I need to select the files/emailaddresses manually. I want to let access do this automatically to reduce the work and chances of errors.
I have a table with the emailaddresses of all employees that need to be emailed and I want to make a selection of emailadresses for a certain document that needs to be emailed to that person/group of persons.
for instance:
01.txt needs to be sent to employee 1 and 2
02.txt needs to be sent to employee 2 and 4
etc
I have managed to make a script to email to one person but how do I get access to use the emailadresses from a table to email automatically?
Thanks for your help.
