Is Outlook Running?

[Scruffy McScruffovitch]

From Access 2003, how do I check to see if Outlook 2007 is running on the
local system? Thanks in advance! I'm using XP Pro.

 

[Stuart McCall]

From Access 2003, how do I check to see if Outlook 2007 is running on the
local system? Thanks in advance! I'm using XP Pro.

--
"A government big enough to give you everything you want is strong enough
to take away everything you have."

Thomas Jefferson

Try connecting to an open instance, something like (air code) :

Dim myObject As Object
Set myObject = GetObject("", "Outlook.Application")
If myObject Is Nothing Then
MsgBox "Outlook is not open"
End If
Set myObject = Nothing

 

[Scruffy McScruffovitch]

In News [email protected],, Stuart McCall at
[email protected], typed this:

Try connecting to an open instance, something like (air code) :

Dim myObject As Object
Set myObject = GetObject("", "Outlook.Application")
If myObject Is Nothing Then
MsgBox "Outlook is not open"
End If
Set myObject = Nothing

Thanks!