Re: Schedule report to run and email it?

Tech-Archive recommends: Speed Up your PC by fixing your registry

JS:

It can be done, to be sure, but it takes a number of steps to automate this.

First, Access has no scheduling capability built in. So you have use
something like the Windows scheduler to schedule Access to run, open your db
and to output a report at a specific time. If you look on our web in the
Code and Design tips area under Reports, there's a discussion of how to do
exactly this and some sample code.

Second, the code in that example will print a report at a specific time, but
you want to e-mail it. So you need to create a whole routine to create the
report as a file and attach it to an e-mail and then send it. You'd have
the vbs run by the scheduler run your routine (rather than output the report
directly as shown in the example) by using the Application.Run
(objAccess.Run) command calling a function that you create in the database
itself that outputs and e-mails the file.

Third. that of course requires that you create a function to automate file
creation and attachment to an e-mail. Using Access' main tools, there's no
way to do this without user interaction. But if you take a look at our PDF
and Mail Library for Access (there may be other tools out there as well,)
you can use it to create a field and e-mail and send it all without user
interaction.

Hope that helps
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


"DEVOURU" <devouru@xxxxxxxxxxx> wrote in message
news:Z4Jke.20743$J12.12721@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Am I asking too much of access to schedule a report to run AND email it?
> TIA
>
> -JS
>


.

Relevant Pages

  • Re: Schedule report to run and email it?
    ... > something like the Windows scheduler to schedule Access to run, ... > db and to output a report at a specific time. ... > create the report as a file and attach it to an e-mail and then send it. ... > no way to do this without user interaction. ...
    (microsoft.public.access.reports)
  • Re: how to email an access report automatically every month
    ... However, it is not necessary, and probably not preferable, to run it via an AutoExec macro. ... In the Command Line of your scheduler, you can specify the macro, somewhat like this... ... command with a report selected or displayed. ... Scheduler to start your Access database at the time you want to send ...
    (microsoft.public.access.gettingstarted)
  • RE: How to stop reports printing with blank fields
    ... I have managed to get round the 'printing reports with no data' problem by ... I have built a simple macro to open a report based on a query, ... if the initial query (on which the report is based) does not return ... I had planned to use the windows task scheduler ...
    (microsoft.public.access.macros)
  • Re: Running unix shell script from remote java app
    ... user accounts, we have one user account for the company. ... Why not automatically run the script, either as the final task in the overnight run or later as a cron job, and have it e-mail you the report? ... You have a choice of scheduler: cron for jobs that always run at the scheduled interval and "at", that a process can use to schedule a following job. ... martin@ | Martin Gregorie ...
    (comp.lang.java.programmer)
  • Re: automate reports
    ... The best way to automate a scheduled send is to use the Windows Task ... Scheduler and a small vb script that runs Access. ... (rather than Outlook Express), you may run into a problem with Outlook ... under reports for the tip Scheduling and Automating Printing of Reports. ...
    (microsoft.public.access.reports)