E Mail Notification

[Slipps via AccessMonster.com]

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

 

[Arvin Meyer [MVP]]

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.

 

[Slipps via AccessMonster.com]

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

 

[Arvin Meyer [MVP]]

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.