Closign Applications with a Macro of VBA

[tmort]

I'm working around an Outlook Security feature that calls for a prompt when sending email automatically.

I would like to create a macro that would be fired up be task scheduler that would first close outlook, then open another MAPI compliant email program without the security feture, ren the sendobject command, close the second mail program, open outlook and then close Access.

I can open the applicatons OK but I'm not sure how to close any except Access.

I tried:

Option Compare Database

Function close_Outlook()
Dim Outlook As Application
Outlook.Quit
End Function


But I'm off base on that. Any ideas

Thanks

 

[bigmaxnosauce]

I'm sure you figure this out by now but for anyone interested

Dim AppOutl As Outlook.Application
Set AppOutl = GetObject(, "Outlook.Application")
AppOutl.Quit
Set AppOutl = Nothing

 

[bbrendan]

hi,

I had the same problem with Outlook security patch. One way to get around it is to use CDO

see this thread

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=28669&highlight=cdo

cheers