There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
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
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Contract Expiration Alert

Reply  
Thread Tools
tonyogbuji's Avatar
Junior Member with 8 posts.
 
Join Date: Nov 2009
Experience: Intermediate
02-Nov-2009, 01:57 PM #1
Contract Expiration Alert
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's Avatar
OBP OBP is online now
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
02-Nov-2009, 02:04 PM #2
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.

Last edited by OBP; 03-Nov-2009 at 09:47 AM..
tonyogbuji's Avatar
Junior Member with 8 posts.
 
Join Date: Nov 2009
Experience: Intermediate
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's Avatar
Junior Member with 8 posts.
 
Join Date: Nov 2009
Experience: Intermediate
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's Avatar
OBP OBP is online now
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
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's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
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/
Reply

Tags
excel e-mailing

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 01:01 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.