Hi ozgrid I’m currently proceeding with an equipment withdrawal system which uses a barcode scanner to scan their office ID. This allows the user to be able to press the check button which uploads their name, department and e-mail address. After the scanning of their office ID, they scan the item they want to loan out. For returns, the process is the same. The data when withdrawing and returning the items is captured into a database in separate sheets called “withdrawal_data” and “ return_data” this is achieved by a user form. One of the main features of this project is to be able to send out an email 3 days before the selected return date. However I do not know how to proceed with this. I have an idea to make the vba program execute a code to send the email out via a clickable button on the sheet. However I have no clue on how to make a program which counter checks against the return list to ensure the item has already been returned which ensures the email will not to be sent out. Some ideas that I have thought of are conditions to be fulfilled in order for the code not be executed the following are stated below.
-The user in both the return and withdrawal section is the same
-The borrowers email is the same
-The loan return date is the same
-The item returned and withdraw is the same
Hence all this conditions have to be fulfilled in order for the email not to be sent out. The idea I have thought of is an VBA code which searches through the ‘return’ and ‘withdrawal’ sheet looking for the above conditions and outputting them into a sheet hence generating a sheet which contains the successful returns. In summary , I am able to send out the emails to remind them to return the items however I do not have a way to stop the emails from being sent out despite them already returning the items please help! Below is my excel file feel free to look through to understand it!