Hi Everyone!
This is my first post here. I need your help in developing a mechanism to send an automated outlook mail to the participant determined in the key, when the due date of a order has passed and no value has been added to the delivered column. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.
In the attached excel file, An email should go of to the email address stated in the key ('KEY '!C5) , with subject "PO NO.('sheet1'!Col. J) has been missed from Supplier ('sheet1'!Col. H)", and body "A delivery from Machine('KEY '!C2) has been missed".
Also, the script should put a check mark on Reminder sent column ('sheet1'!Col. M) after the email is sent, the script should also check if the value of the cell is blank before sending email.
I have scoured the forum for similar problems, and although I found a number of of threads, I am not proficient enough in VBA to modify them to my needs.
I'd really appreciate any help,
Thanks
Bookmarks