Expiration Email

Hi All,

I work at a Fire Department and I am trying to automate excel in such a way that it emails me when items need to be replaced. I have an inventory of all the equipment on the apparatus and when that equipment expires. What I would like is for an automated email to be send out to several members 4 months in advance of the expiration date. This will allow us to have enough time to replace the expiring equipment and no longer having to keep hard copies of everything.

Is this possible?

Thanks

Here is my workbook. I haven't entered in the information. What do I need to do to make it happen?

Thanks. USAR INVENTORY.xlsx