adstam
Technical User
- Feb 28, 2001
- 25
I have an VBA application (in MS Access) as an interface between an access database and outlook contact files.
The connection to outlook is set up by using
Dim ObjOutlook as Outlook.Application
Dim Nms as Outlook.NMS
Set ObjOutlook = CreateObject("outlook.application")
Set Nms = ObjOutlook.GetNamespace("MAPI")
At the end of the procedure the variables are set to Null:
Set ObjOutlook = Null
Set Nms = Null
The procedure starts an Outlook process in Windows. At the end of the procedure MS Access is closed down, but the Outlook session is not killed. Everytime the procedure starts there is a new outlook process created.
Do i do something wrong with starting the outlook process, or is there a way to stop the outlook process at the end of my vba procedure?
Ad
The connection to outlook is set up by using
Dim ObjOutlook as Outlook.Application
Dim Nms as Outlook.NMS
Set ObjOutlook = CreateObject("outlook.application")
Set Nms = ObjOutlook.GetNamespace("MAPI")
At the end of the procedure the variables are set to Null:
Set ObjOutlook = Null
Set Nms = Null
The procedure starts an Outlook process in Windows. At the end of the procedure MS Access is closed down, but the Outlook session is not killed. Everytime the procedure starts there is a new outlook process created.
Do i do something wrong with starting the outlook process, or is there a way to stop the outlook process at the end of my vba procedure?
Ad
