I have a system (Access 97) which is 2 weeks overdue. The one thing we need is a routine which will, at a particular time, go through a list of company names and either fax, email, or print a report for/to each company. This needs to be done unattended.
The timing won't be a problem, neither will be the retrieval of the list from the database. If the program is provided with a desired output mode (say txtOutMode), and a phone number or email address (say txtAddress) as appropriate, how can I do this? It would be preferable if the coding were done within the database, since that is where the report is being generated.
This one is fascinating, and I wish I had the time to research it myself. Any help would be appreciated.