View Single Post
  #3  
Old April 21st 08, 03:10 PM posted to microsoft.public.outlook
gamul
external usenet poster
 
Posts: 9
Default How to run a batch file wen you close Outlook


" ...

"Vince Averello [MVP-Outlook]"
...
There's a possibility that you could add code to the Application_Quit()
event in the VBA editor but you'd still have to code it yourself

"gamul" wrote in message
...
Doesn't Outlook have the built-in function of starting scripts during
closing?


So as recommended me user Gordon (in different thread) I wrote VBA script,
which copies files .PST to or from net.
I would like to start this script every time when user logs in to computer
as well as when Outlook switches off.

There's a possibility that you could add code to the Application_Quit()

Please, continue with this think.



Ok.
It with my tests results, that this can be made across macro in Outlook
(thanks Vince Averello):
Sub Application_Quit()
Dim RetVal
RetVal = Shell("D:\temp\mm.cmd", 0)
End Sub

mm.cmd looks so:
D:\temp\proc.vbs

It works!

It during starting Outlook, was can this make (how Brian Tillman advised in
different thread) creating shortcut starting Outlook which will look so:
call D:\temp\proc.vbs
"C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE"

I thank for help with all.
I greet.


Ads