withoc
04-08-2008, 03:16 AM
Please help:
Within MS Access 2003 I want to send an automatic e-mail when a particular cell reaches a certain level.
E.g. Within my database I want to be alerted via an e-mail once a field reaches a certain level. E.g. I have recieved a number of service calls for a certain postcode.
It would be like an module run within an if statement.
I am ok using "sendobject" within the macro function but struggling linking it to an "IF" statement.
Any help from anyone would be greatly appriciated.
Many thanks.:confused:
Within MS Access 2003 I want to send an automatic e-mail when a particular cell reaches a certain level.
E.g. Within my database I want to be alerted via an e-mail once a field reaches a certain level. E.g. I have recieved a number of service calls for a certain postcode.
It would be like an module run within an if statement.
I am ok using "sendobject" within the macro function but struggling linking it to an "IF" statement.
Any help from anyone would be greatly appriciated.
Many thanks.:confused: