creating an autoexec macro that runs several reports in snapshot

  • Thread starter Thread starter SOT
  • Start date Start date
S

SOT

Hello All,

Does anyone know how to create an autoexec macro that runs
several reports in snapshot version and email the
distribution list in outlook? After the email is sent it
will then close the database. If there is an easier way to
accomplish this task please let me know. Any suggestion
will be greatly appreciated. Thanks.
 
You can do it in code using the 'sendobject' command. See help fiels for
more info. You could put this code into a module and run it from your
autoexec macro.

Rick B


Hello All,

Does anyone know how to create an autoexec macro that runs
several reports in snapshot version and email the
distribution list in outlook? After the email is sent it
will then close the database. If there is an easier way to
accomplish this task please let me know. Any suggestion
will be greatly appreciated. Thanks.
 
We have an batch reporting email example in our eval. It doesn't use the
built-in
sendobject from Access and instead uses a third party DLL for emailing (I
think it is
a better route to go). That way you don't get caught up in issues with
Outlook and it only requires
one DLL to exist in the same directory as your MDB. Also why not use PDF
instead of snapshot?

Basically you do have to open the database, run some code and close the
database.
Unless you want to use an external program to run Access via automation
which is close to the same
idea except the code would be in the external program.

My two cents,
Mark
RPT Software
http://www.rptsoftware.com
 
Back
Top