Automatic emailing and schedule?

Hi
in my workspace we use an excel worksheet shared between 5 users, this is used to track times of testing to test various products using various test suites, during certain times tests are assigned to users by comments being attached to the date of the test combination using our initials.

I know that you can set emails from specific cell values but can you set emails to be sent from comments? and if so would it be possible to further condition it so if initials AA are commented that it would send emails to AA@email.com but if initials BB then the cell would be emailed to BB@email.com?

and finally, if this is all possible would I be able to apply a schedule so that all these cells commented with initials will send the emails to the users only at a specific time?

any help you can provide would be greatly appreciated.
Kind Regards
Kaidan Baird