Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SENDING A REPORT TO A HOTMAIL ACCOUNT AUTOMATICALLY
- Thread starter chubby
- Start date
I'll give you an example that I use with access, nt and outlook...
1 create a module to run the report and programmatically send it to the user...
2 create a dos batch file that launches access, load database and executes the module like the following:
path and filename of access program (eg. c:\ACCESS\msaccess.exe)
path and filename of database /x modulename (eg. c:\databases\mydatabase.mdb /x myModuleName)
3 use task scheduler in nt to run the task 3 times a week.
Note: the computer must be on and connected to outlook
Trisha
padinka@yahoo.com
1 create a module to run the report and programmatically send it to the user...
2 create a dos batch file that launches access, load database and executes the module like the following:
path and filename of access program (eg. c:\ACCESS\msaccess.exe)
path and filename of database /x modulename (eg. c:\databases\mydatabase.mdb /x myModuleName)
3 use task scheduler in nt to run the task 3 times a week.
Note: the computer must be on and connected to outlook
Trisha
padinka@yahoo.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question