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.

We’ve created two example spreadsheets for you to use while practicing these tasks: 

The example spreadsheet in full, including macros: 

download

Use this spreadsheet to practice creating Excel alerts and writing macros for them. Note: This spreadsheet includes the macros. JD Sartain

The example spreadsheet without the macros, in case you’re unable to download the one with the macros. 

download

Use this spreadsheet to practice creating Excel alerts and writing macros for them. Note: This spreadsheet does NOT include the macros. JD Sartain

Create the spreadsheet, and enter the formulas

You can setup your spreadsheet to alert you when a deadline is approaching or when the invoice is due using the Conditional Formatting feature. Then it can send an email to remind you that the invoice is due.

1. Download the Excel Alerts spreadsheet above (without macros) or create or use one of your own. 

2. In cell A1, enter the function: =TODAY().





READ SOURCE

LEAVE A REPLY

Please enter your comment!
Please enter your name here