Mourning the loss of our friend, WhitPhil.
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Business Applications
Tag Cloud
access audio black screen blue screen boot bsod connection crash desktop driver drivers dvd email error excel firefox hard drive hardware hijackthis internet keyboard laptop malware monitor motherboard network networking outlook problem recovery registry cleaner router safe mode screen slow sound spyware tdlwsp.dll trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Contract Expiration Alert

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

 
Thread Tools
tonyogbuji's Avatar
Junior Member with 7 posts.
 
Join Date: Nov 2009
Experience: Intermediate
02-Nov-2009, 12: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 offline
Computer Specs
Distinguished Member with 9,341 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
02-Nov-2009, 01: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 08:47 AM.
tonyogbuji's Avatar
Junior Member with 7 posts.
 
Join Date: Nov 2009
Experience: Intermediate
03-Nov-2009, 10: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 7 posts.
 
Join Date: Nov 2009
Experience: Intermediate
03-Nov-2009, 10: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 offline
Computer Specs
Distinguished Member with 9,341 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
03-Nov-2009, 10: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 6,294 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
03-Nov-2009, 11:32 AM #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 Bookmark and Share

Tags
excel e-mailing

Smart Search

Find your solution!



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


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 10:22 AM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Powered by Cermak Technologies, Inc.