Hey guys,
Not sure if this is the right forum for this.
I am trying to get excel to send an email if cell H2 is greater then 0. I want it to send one email per day at 1AM.
The email message can say:
Hello,
You currently have "x" production reports due.
Thanks.
Is this possible?
yes this could be achieved thru VBA but would require a small amount of coding
however....for the timing to work.....the spreadsheet would need to be opened at that time
if that is not possible.....maybe a macro to run every time the sheet is open? or on command when you want to?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Welcome to the forum.
Pls take some minutes to read forum rules before you post again.
As in your newest thread have at least one code suggestion, for this time i'll close this one. So:
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks