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 dns drive driver drivers error ethernet excel freeze games gaming graphics hard drive hardware hdmi internet java laptop malware memory monitor motherboard network printer problem ram random registry router slow software sound trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Automatic Email Alerts for conditions in excel cell

Reply  
Thread Tools
Vikashee's Avatar
Junior Member with 4 posts.
 
Join Date: Nov 2009
Experience: Intermediate
03-Nov-2009, 07:49 AM #1
Exclamation Automatic Email Alerts for conditions in excel cell
I have read reviews on forum on same . But still could not find a soultion probably becoz i am not savy with excel . We are basically in to procurement of material . Currently the problem we are facing is that we are not able to track ,whethe the credit period of the supplier has finished and we have paid him or not ? From best of my excel knowledge i was able to establish a formula for same and was sucessful too .i was getting information on Gap b/w payment date and todays date .Moreover I got visual indicator for same , by conditional formatting . Now my boss wants me to make a provision in the excel sheet that once teh payment date has expired , he should keep on getting reminder for same as outlook message with suppliers name and order detail . I have tried alot for same on base of information given on the forum and infact downloaded and installed Click yes active. ver1.2 too Since i dont know VB so i am not able to solve thsi problem. Can any one help me on ths issue as it is important for my promotion .The file is ready for me and can be uploaded on request .
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, 08:36 AM #2
Vikashee, welcome to the forum.
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.
It is a pity that your Boss is Excel orientated as Access is a much better platform for Material Procurement.
__________________
OBP
I do not give up easily
Rollin_Again's Avatar
Senior Member with 4,273 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Brilliant When Sober
03-Nov-2009, 10:46 AM #3
Can you post a sample workbook showing your data layout?

Regards,
Rollin
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
03-Nov-2009, 10:53 AM #4
Zack did most of this last year. Here is the link to his work:
http://forums.techguy.org/business-a...rts-using.html
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:33 PM #5
Or, Daniel Curran has made a sheet that is simple to use and free to download:
http://danielcurran.com/outlook/how-...il-from-excel/
Vikashee's Avatar
Junior Member with 4 posts.
 
Join Date: Nov 2009
Experience: Intermediate
06-Nov-2009, 09:18 AM #6
Enclosed the file
thanks for ur replies . I was out of town so i could not respond immediately . Please find enclosed the file .
I am also mentioning the thread ,which I have used for intial reference . Now doubt their was a goodexplanation but i was not bale to grasp much of it. Could u suggest me a simple VB program , which i can copy paste in the sheet or a simple excel formla so that it starts working . I really thank you guys for bearing with me and supporting me .
http://forums.techguy.org/business-a...s-using-2.html
Attached Files
File Type: xls PAYMENT ADVICE.XLS (40.0 KB, 66 views)
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
06-Nov-2009, 01:10 PM #7
First, I would suggest you change your formula from what you have in column A to
=IF(H6="","",IF(J6-H$2=0,"",DAYS360(H$2,J6)))
Then you can drag the formula down A and it will not give you a bunch of cells that look like #####. due to today's date being entered there in a negative (e.g. Nov. 6 as a negative is -39546.)
This formula also has some problems, given your conditional formatting, but not as much as you would have had.
Oh, also, the "$" in H$2 forces the formula to always look at that cell - if you drag the formula down the column without the dollar sign, it would then look at H3, then H4, and so on.
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.
My theme song... | Affero - rate me!
Vikashee's Avatar
Junior Member with 4 posts.
 
Join Date: Nov 2009
Experience: Intermediate
07-Nov-2009, 05:17 AM #8

I have gone through Daniel Curran excel sheet ( t3.xls) it is really simple to use but only a partial solution to my problem . If I correlate my requirement to his sheet then it can be explained as follows . In the given sheet (t3.xls) u have to click sent mail , however my requirement is auto trigger ,i.e mail should go on its own to the desired email id . the condition is that the trigger should be set once a condition is met , say in my case ( t2.xls ) delay period when reaches 7 days the mail should shoot to the given email id . Can u help me understand the same by customizing t3.xls , with any such if then condition and setting a auto trigger .It would be really great if u could make necessary changes in t3.xls VB program . Thanks again
Attached Files
File Type: xls t2.XLS (18.0 KB, 70 views)
File Type: xls t3.xls (58.5 KB, 68 views)
Reply

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:51 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.