Trigger E-Mail from Record count

[Wonderer]

Hi All,

I was hoping someone could help i have my script to trigger an e-mail but i have always used a button. However i have a table which is populated with account number however i have to enterthem in as there is no specific rule assoiated with the numebrs. When however i have used all the account numbers i need an E-mail to trigger informing somone they need to add in a new set of account numbers does any one have any ideas or have done anything similiar?????

Can i trigger script from my P.C clock to check this?

Your help would be much appreciated

Regards

Rob

 

[llkhoutx]

Use the form Time Interval propertyand OnTimer event. It has minimal overhead and could be run periodially, transparent to the user, at specific time intervals.

I'd test the account number table every time a new account number is added. When it reaches some level, trigger the email.

 

[Wonderer]

Thanks for your response

"I'd test the account number table every time a new account number is added. When it reaches some level, trigger the email".

any ideas on the script you could use to carry this out?

 

[llkhoutx]

Note the form's TimeInterval (thousandths of seconds) and the OnTimer event.