how to set up email alerts in excel

Microsoft Excel 2007 home and student
January 11, 2010 at 10:01:30
Specs: Windows Vista
hi I would like to set up an email alert in excel what I am doing is that when my plan comes up for renewal it will automatically send me an email alert to remingd me

is this possible to do ?


See More: how to set up email alerts in excel

Report •


#1
January 11, 2010 at 20:10:56
re: when my plan comes up for renewal

What plan?

Please give us a little more detail as to what you are trying to do.


Report •

#2
January 12, 2010 at 03:40:15
The only way that I can think of is by using the Calendar function of Outlook. This will then create an alert when nearing the event. To do this will require VBA

Look at this post for one way of doing it

http://www.eng-tips.com/viewthread....


Report •

#3
January 12, 2010 at 05:10:30
re: "The only way that I can think of is by using the Calendar function of Outlook"

There may be ways to do this within Excel itself, but we need some more info.

Dates can be checked upon the opening of the workbook and emails sent, etc. It might be tricky to do without opening the workbook (or at least some workbook) so that some action occurs to cause the date to be checked.

The workbook can't just be sitting in a folder checking itself.

In any case, VBA would ceratinly need to be involved.


Report •
Related Solutions


Ask Question