If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
E Mail Notification
Hi
Could someone help please. If my marketing % goes up or down from a number, I would like to know the code to send me an instant e-mail alert if this happens Thank you -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
E Mail Notification
Slipps via AccessMonster.com wrote:
If my marketing % goes up or down from a number, I would like to know the code to send me an instant e-mail alert if this happens Look up send object in the help files. Access doesn't have Triggers, so the only way you can run code to check for a condition is to run code from a form. You need to use an event to run the code. It can be a timer event, if you want it to be done at regular intervals, or you can use another event such as opening the database to check. You can also schedule an operation from Windows, using a Windows scheduler, to open Access and have a startup form check for the condition, and send the email, if required. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#3
|
|||
|
|||
E Mail Notification
Arvin Meyer [MVP] wrote:
If my marketing % goes up or down from a number, I would like to know the code to send me an instant e-mail alert if this happens Look up send object in the help files. Access doesn't have Triggers, so the only way you can run code to check for a condition is to run code from a form. You need to use an event to run the code. It can be a timer event, if you want it to be done at regular intervals, or you can use another event such as opening the database to check. You can also schedule an operation from Windows, using a Windows scheduler, to open Access and have a startup form check for the condition, and send the email, if required. Thank you for your reply. Can I ask is there a formula/code for this I could use in excel or am I in the wrong site for this? Thank you -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
E Mail Notification
"Slipps via AccessMonster.com" u47828@uwe wrote in message
news:9d21e1d14c25a@uwe... Arvin Meyer [MVP] wrote: If my marketing % goes up or down from a number, I would like to know the code to send me an instant e-mail alert if this happens Look up send object in the help files. Access doesn't have Triggers, so the only way you can run code to check for a condition is to run code from a form. You need to use an event to run the code. It can be a timer event, if you want it to be done at regular intervals, or you can use another event such as opening the database to check. You can also schedule an operation from Windows, using a Windows scheduler, to open Access and have a startup form check for the condition, and send the email, if required. Thank you for your reply. Can I ask is there a formula/code for this I could use in excel or am I in the wrong site for this? You should ask Excel questions in an Excel newsgroup. I'm not sure that you could do this from Excel, but if you have a scheduler that opens and reads 1 or more cells, you may be able to do so. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
Thread Tools | |
Display Modes | |
|
|