Automatically Distrbuting Reports from Access

[purceld2]

I have been told you email reports from Access and also you use the windows task scheduler to start the application. So my questions is

Can we tie them all together and get Access to startup automatically run in the background kick a macro which starts a report distribution function via email and then close.

If so does anybody any existing code,

Regards

 

[MSAccessRookie]

I have been told you email reports from Access and also you use the windows task scheduler to start the application. So my questions is

Can we tie them all together and get Access to startup automatically run in the background kick a macro which starts a report distribution function via email and then close.

If so does anybody any existing code,

Regards

I do not currently do this, but I imagine that you could create a version of your Access Database with a Startup Form that executes your Macro (or preferrably VB Code) when it Loads. As long as it waits (DoEvents) for all events to complete before exiting, it could provide what you are looking for.

 

[pbaldy]

You don't even need a form. I'd put all the code in a function and run the function from an AutoExec macro. The last thing in the function code is a Quit.

 

[purceld2]

What I wanted to know is can you imbed the recipients email address in the code?

Thanks you in advance for your help

 

[pbaldy]

Yes, of course.

 

[pbaldy]

There's a lot of email info here:

http://www.granite.ab.ca/access/email.htm