Excel Macro to send notification email when items pass a certain date

Hi all,

My first post on this forum, which so far has helped no end, however i have a requirement for something a little more complicated than i am used to.

I have a iventory of PPE (personal protective equipment), each of these items have separate (some the same) dates where checking or recertification is required, I would like to set up a system that will allow an automatic marco to run when opening the workbook to flag items within a certain date (example 1 month before an item goes out of date) and send a notification email with the item, its location and its unique number. An example of what my information looks like is below (hopefully).

Any help would be appreciated, I think it may be a useful tool for others too.

Best Regards,

Krist87

PPE.xls