Yes, the button sends the e-mails. Do you want me to send the database to you with the changes I made?
File ID: 846500
No. I need the date to activate the e-mail automatically.
Yes. The database I sent you is only a simple sample. The equipment they are dealing with are large and dangerous if not properly kept up. The boss wants to make sure that when a compressor inspection date is due, the two supervisors will be notified to completed the inspection on time. He has to deal with OSHA if they are not done on time. It is important to send the e-mails on the various dates that the inspection are due.
I have as many as 10 databases for each facility and as many 40 pieces of equipment. It makes it impractical for someone to press the buttons every day. I would like to try automatic and see how it goes.
I will see if it sends the e-mail tomorrow.
If in the future you think of a better way of accomplishing this task, please contact me. I will gladly pay for the information.