Contract Expiration Alert

tonyogbuji · 02-Nov-2009, 01:57 PM #1

Is there any free tool that can alert me by e-mail when the dates on a column of excel worksheet is ealier than the current date?

OBP · 09:47 AM

If you wish to do this while Excel is open a VBA macro can do that for you, there are already a few Examples on here.
If you want to open Excel and do the test you will need some VB Script or to use Windoes Task Scheduler.

tonyogbuji · 03-Nov-2009, 11:11 AM #3

Thanks for your help! But is there no free tool other than VB script that I can use to achieve this?

tonyogbuji · 03-Nov-2009, 11:14 AM #4

Thanks for your help! Is there no other free tool that I can use to achieve this.

OBP · 03-Nov-2009, 11:17 AM #5

Non that I know of, if you watch this thread
http://forums.techguy.org/business-a...ons-excel.html
you may get the answer to the VBA that you require, if not we can create it for you.

slurpee55 · 03-Nov-2009, 12:32 PM #6

Daniel Curran Has a sheet already made for you to use - it is VBA, but what is wrong with that?
http://danielcurran.com/outlook/how-...il-from-excel/

Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard netgear network printer problem ram registry repair router slow software sound toshiba trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!