Help with sendobject!!!

[Newguy28]

Hey Guys,

I have the sendobject currently working so that when the database is opened, it sends the required mail. But i would like it to send an email once a month, is there a way around this??

 

[Oldsoftboss]

Maybe something here ... http://www.access-programmers.co.uk/forums/showthread.php?t=62570&highlight=date+functions

will at least help with the first day of the month.

Dave

 

[reclusivemonkey]

Just ammend your code to check the date. Use a date which is present in every month; for example if you choose the 30th, then you won't get one in February. You should also record the year/month that an email is sent, so that when you open the database again on the same day your email is sent, you don't send a duplicate.