Alex,
What you have described makes sense from my limited perspective. However I am really clueless as to how to implement it. I was hoping someone else was doing this out there but maybe not.
The date to be updated is in the employees tbl so the index is EmployeeID.
Thanks
Will
Alex,
Below is the active x I currently am running to get the whole view in an email. I found this code as an example in a resource and simply modified it slightly for my use.
If I could get it to send individual emails and update the date field it would save me a tremendous amount of time...
I need an Active x script to send emails to addresses that are listed in a view then update a related table with getdate() once the email has been sent.
Basically the view will find the employees in a particular department from employeetbl were that department has updated news from the...
I need an Active x script to send emails to addresses that are listed in a view then update a related table with getdate() once the email has been sent.
Basically the view will find the employees in a particular department from employeetbl were that department has updated news from the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.