How to close Outlook from Access VBA code

[Marco]

Hi. Does anyone knows how to close outlook from a access VBA command line?

Thanks,
Marco

 

[bhicks11 via AccessMonster.com]

DoCmd.Quit

Bonnie
http://www.dataplus-svc.com

Hi. Does anyone knows how to close outlook from a access VBA command line?

Thanks,
Marco

 

[Marco]

Hello,

That will close the access application.


Marco

 

[MikeB]

Hi. Does anyone knows how to close outlook from a access VBA command line?

'Outlook has to be running first
Private Sub CloseOutlook()
Dim objOLook As Object
Set objOLook = GetObject(, "Outlook.Application")
objOLook.Application.Quit
End Sub