Expiry dates - to send automated emails

[jake.jay]

I have a lot of employees, with sensitive information that has expiry dates. to keep on top of all of this I would like to know if it is possible to send an automated email using the email addresses in the B column and while keeping myself CC'd in 60 days before it expires and 10 days prior as an urgent attention required. if possible I would like this to be able to be complete without the spread sheet being open.

Ideally the information in the email will have;

URGENT ATTENTION FOR (LINE MANAGER)
Employee - (surname) (first name) has got his (whatever is due for expiry from row 6) coming up for its expiry date

Any issues please contact your supervisor

I have attached a sample spread sheet with how I have it set up at the moment - conditional formatting to highlight in red expired and amber 60 days before problem is im not always in the office to keep on top of this information.

I use Excel 2010 and outlook.

Any help would be greatly appreciated.