If you wanted the subroutine you already have for mailing the sheet to active when one of the cells in columns F or I contains a value of 30, you could use the following code. I've assumed a name for your mailing subroutine as 'MailSubRoutine'.
It should be fairly obvious, but the above code simply looks in columns F and I for any cell with a value of 30. If it finds one, it will trigger the subroutine called MailSubRoutine.
Is that what you were looking for? Apologies if I've misinterpreted, but I'm new here and am keen to help others as much as I ask for help myself!
Edit: With regards to RoyUK's comment above, I assumed you simply required the email to be sent to yourself or a single other individual. If you wanted it sent to the person whose licence is expiring, you'd obviously need to have their contact details located somewhere in the spreadsheet too. The short section of code I've put in above can be used to look in a single column, as well as the two columns of expiries.
Bookmarks