Automatic Email Alerts based on due date in Excel Via Outlook

Hi There,

I am hoping someone out there can help me... I am reformatting our current budget spreadsheet and I want to be able to keep better track of our invoices. I would like to set up a macro that will scan the data for overdue dates (based on either the words 'over due' or the actual dates) and then automatically create an email with the correct product code in the subject line and the email address of the relevant company. On top of this I would like it to run automatically everytime the workbook is opened. I am pretty new to using VBA codes so have not been able to just adapt other peoples that I have found online. Is this possible?
Look forward to seeing if anyone has my answer!

Excellent! Thanks very much. Ok so attached is the template of one product's budget table, however the actual workbook will contain a number of these with each sheet representing a diferent month. The product code is the one starting EIF... this is what I wanted the subject to be if possible, and the alert to appear is the Invoice due date has passed and the actual invoice date cell is still blank... I realise this is starting to sound a lot more comlicated so if there is an easier way of creating this by playing around with the excel sheet instead please let me know! Thanks again for your help.

Any luck with this one?

did u get help? I have the same problem