I have searched several forums over the last week and have found several references to using the CDO method. I have not been able to find one instance of it being applied to a Access database which i could rework to my particular application. I have experimented with the sendobject but it requires user intervention and i needed something i can setup to run every night using windows scheduler without any user intervention.
I have a Access database which tracks office communication, on receipt of a inquiry the letter is assigned to a particular department with an supervisor and analyst who are responsible to research the required information and provide a respond by a particular due date. if the due date is between Now () and Now + 5 then send email to Head of communication and their assistant also cc department supervisor and analyst. When email is sent update field on record with date of notification.
in my current environment there is a Microsoft Exchange server which i do not have access to, also an SMTP server on port 25 which we use to send email to users with various other applications.
I have created a couple of databases but my skill level when it comes to adapting vb code or functions to accomplish various tasks in access is low.