email automation

[teiben]

I think I read every post on the subject. I already have a few db in which a user hits a command button and the email message sends.

What I want is a email message that runs each Monday morning and emails out a report.

From what I've read though it's been posted that it can't be done w/out user intervention? Is this correct?
So in order to be done, you have to set it up through the window scheduler?

**Got some great tips reading the posts, especially about not hard coding command buttons, but rather put them in a table.

 

[Travis]

In order to do it with MS Access, you would need to have the Access Database open. You can use a Form's Timer Event to check the date and time and then fire off the event that does the email.

You can use the windows scheduler to run the database every Monday.


However, you could go with a C, C++ or even VB (preferibly VB.NET) windows service. This would only require that the PC be turned on.

 

[teiben]

Good thinking, the db would be open, so the timer code sounds easier.

Any idea about how the code should be written?
Thanks a million

 

[Travis]

It should be the same code that you use on the command button, with these differences.

1. It should be a Public Sub/Function in a Module
2. This Sub/Function should be called on the Timer Event of the Form