Hello,

I need help figuring out how to send an email automatically from an excel file once the expiration date has passed. I would also like to have an email sent 30 days prior to the expiration date. I am not very good with this aside from simple mathematical coding. The formate should be as such, A1 = part number , B1 = letter code , C1 = descirption , D1 = quantity , e1 = unit of measure , f1 = status , g1 = lot number and h1 = expiration date. The only column i am concerned about is the expiration date.