Excel macro to send email through outlook when expiry nearing

Hi, I am trying to make an inventory list with the expiry date of various chemicals. There is a user form which I have not coded yet. What I hope to do is have the macro send an email regarding which chemical is expiring within 90 days to a group of people. Any help will be appreciated, Thanks

I've put a macro in called SendMail which will check the date in the D column, and send if the date is equal to today.
Dead simple to put your own If statement in

Inventory expiry.xlsm

It is untested, but based on an email macro I use daily.

Hi aaron, thanks for your help. How do I get the macro to send the mail with the body of text that includes the chemical and the date that it is expiring at?

oh and i tried the macro. It didnt work though. I didnt receive any emails regarding the expiring chemical