Automatic Email?

[Scoob55k]

Can you set an email to be sent out from Access automatically every Monday morning at 7am? I'm thinking no as one would have to have the Access application open as well as their email program for it to work. An Access with multiple users may just complicate the issue.

Just thought I'd throw it out there. I'm sure it's a possibility, but controlling all the after effects can be the issue. Thanks!!

 

[PaulBricker]

The short answer is yes. The basic process is
1. Write a function that opens Outlook, and loops thru a recordset and creates the emails you want.
2. Call that function from a macro
3. Use MS Scheduler to open Access each Monday morning and run the macro.

If you need specifics, just post back.

Paul

 

[mp9]

You may also find the Handy Access Laucnher useful for scheduling the macro approach that Paul advocates.