date function question (1 Viewer)

[bonekrusher]

Hi All,

I am using a date function that will send an email out on the first of the month. It runs on an "on open" event. My question is how do I get it to run once? Because the way I have it set up now, if the database is opened 20 times on the first of the month, it will send the email out 20 times.

any idea?

thx

 

[modest]

Make a table for when emails were sent.

If Date Not In Table then
SendEmail
End If

Or instead of doing the On Open, just attach it to a button and manually send it