Hi Relatively new to the forums: been browsing the majority of post to try and edit the VBA codes to my needs. I've yet to succeed with my attempt.
Project in short: I'm creating a complaints log, Straight forward stuff complaints are entered and edited via userforms which then place the data onto the Database tab, what I'd like to implement is an email system that will automatically send an email if a certain complaint goes over a certain date (lets define this variable as X). I want the VBA code to look at column T and see if there is a 1 if not it should look at column S to find the a Value (this is an if statement saying if the date difference X goes over a set limit put a 1), if it does send an email from that particular row then place a 1 in column T. This should hopefully eliminate spam.
This will increase in size (so a predefined range won't work) don't take the format I've uploaded as the actual document.
I'd like the email to contain certain values within that specific row, Customer ID, Customer Name and Department
Now I've browsed forums and looked on a few sites (that Rob site about sending emails), Nothing has met the criteria I'm after
I've attached the workbook any help will be greatly appreciated
Bookmarks