E Mail Notification

Slipps via AccessMonster. · External Since: Oct 04, 2009 Posts: 2

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

Arvin Meyer [MVP] · External Since: Jan 09, 2009 Posts: 74

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

Slipps via AccessMonster. · External Since: Oct 04, 2009 Posts: 2

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

Arvin Meyer [MVP] · External Since: Jan 09, 2009 Posts: 74

"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