automate reports

  • Thread starter Thread starter k.j
  • Start date Start date
K

k.j

hi,
I am using MSAccess 2000.
I would like to automatically generate reports and send them vie email on a
schedule basis,
What is the best way ?
I am considering using DoCmd.SendObject method but how can I automate the
process (without user intervention) ?
Regards,
kris
 
kj:

The best way to automate a scheduled send is to use the Windows Task
Scheduler and a small vb script that runs Access. The only problem when
using SendObject, is that if you are using Outlook as your mail program
(rather than Outlook Express), you may run into a problem with Outlook
popping security prompts with each mail send. This started with Outlook
2000 after application of service release 1. You can work around that by
setting Outlook Express as your default mail program and if you are using OE
6 unchecking the "Warn Me when other applications try to send mail as Me"
option on the security tab.

If you need an example of automating Access using the Windows task
scheduler, then stop by our web and look in the Code and Design Tips area
under reports for the tip Scheduling and Automating Printing of Reports .
You can modify that script to run Send Object calls rather than printing
reports directly.
 
You can use our product to create all the PDF files and then create
all the emails with PDF attachments and send them.

We recommend using a third-party email DLL such as ASPMail, it's one file
and it saves you
from all the hassles when trying to use built-in Access methods.

We sell full source code so your end solution is just another module in your
Access database
and a few extra tables.

Download a free eval and try it out,
Mark
RPT Software
http://www.rptsoftware.com
 
Back
Top