E-mail; Birthday reminder, Week difference

Hello Everyone
I tried to look at the different solutions avaiable for sending an e-mail a week before a person has birthday, but couldn't find one that tackled the exact problems that i'm facing.

In our company we have an excel sheet containing the birthdays of the employee's. The excel sheet is only opened when a new employee is hired and a corresponding birthday has to be registered. Is it possible to make a VBA code that automatically sends out a reminder a week before someone has birthday to 3 different e-mails under the constraint that the excel sheet is not being opened on a regular basis? We're btw using Outlook for e-mail correspondence.

See file for example
Hope you can help.