No probs, the VBA lingo can be quite overwhelming at first but keep at it!

(Just a few notes I thought of -

You'll need to figure out a way to STOP the re-sending of information/ e-mails, maybe a test on interior.color of a cell - Its currently set to VbGreen if it's already sent . Also To trigger this sub on opening of the workbook, add the code below into 'ThisWorkbook'

Private Sub Workbook_Open()

Call ExpirationAnalysis

End Sub
)