View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Need VBA Code to check if MSOutlook is open


Hi,

Try this

Sub TestOutlook()
On Error Resume Next
Set oOutLook = GetObject(, "Outlook.Application")

If oOutLook Is Nothing Then
MsgBox "Outlook isn't open"
End If

End Sub

Mike

"TPJoseph" wrote:

Can someone please provide an example of VBA Code to check if MSOutlook is
open?

Thanks,

Tom