Need VBA Code to check if MSOutlook is open
 

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

Thanks,

Tom

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

Need VBA Code to check if MSOutlook is open
 

Check out the below link to handle this and open outlook if not

http://www.ozgrid.com/forum/showthread.php?t=73886
--
If this post helps click Yes
---------------
Jacob Skaria


"TPJoseph" wrote:

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

Thanks,

Tom

Need VBA Code to check if MSOutlook is open
 

Thanks, Mike.

"Mike H" wrote:

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

Need VBA Code to check if MSOutlook is open
 

Thanks, Jacob.

"Jacob Skaria" wrote:

Check out the below link to handle this and open outlook if not

http://www.ozgrid.com/forum/showthread.php?t=73886
--
If this post helps click Yes
---------------
Jacob Skaria


"TPJoseph" wrote:

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

Thanks,

Tom