Automatic Email Updates

[erinkleiman]

I need to send an automatic email update every week when a certain event does not happen. Does anyone know if this is possible in Microsoft Access and if so how I would go about doing this? =)

 

[shacket]

You would use:

DoCmd.SendObject

to send an e-mail. Use VBA (perhaps when the database is exited?) to test for the certain event and send the e-mail if it has not occurred.

HTH

 

[Nero]

This link may point you in the right direction for coding.http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30353

You would need to add some code to test for your event.

Kev

 

[erinkleiman]

Event Exit Dabase

Shacket....
I have my code written and ready but I need to know what kind of module or macro I should use to implement this code when the database is exited.
Thanks a bunch!

 

[shacket]

If you only want to perform the test once every week, I would create a separate database that does the following:

(opens)
Checks to see if condition is met
Sends e-mail
Closes

Open this database weekly using task scheduler.

You would have the autoexec macro run VB code, which would look something like this:


** Check for the condition

If Condition = True Then DoCmd.SendObject ...

DoCmd.Quit (might be DoCmd.Close)

HTH