Create Excel Alerts, then write a macro to email them

Can Excel send Alerts? Yes, but with some limitations. Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function. And, the reminder Alert only works if the Excel software is open. Not quite the convenient method you were hoping for, right?Another option, although complicated and limited (at this time) to the XLS spreadsheet formats only, is to set up your spreadsheet like an Outlook Calendar, then import the data from one to the other. But this method is not really a satisfactory result either. So, until Microsoft decides to provide a functioning solution, we have to settle for work-arounds, using macros plus a little manual intervention for the email.To read this article in full, please click here