T TPJoseph Jul 7, 2009 #1 Can someone please provide an example of VBA Code to check if MSOutlook is open? Thanks, Tom
M Mike H Jul 7, 2009 #2 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
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
J Jacob Skaria Jul 7, 2009 #3 Check out the below link to handle this and open outlook if not http://www.ozgrid.com/forum/showthread.php?t=73886
Check out the below link to handle this and open outlook if not http://www.ozgrid.com/forum/showthread.php?t=73886
T TPJoseph Jul 7, 2009 #4 Thanks, Mike. Mike H said: 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 Click to expand...
Thanks, Mike. Mike H said: 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 Click to expand...
T TPJoseph Jul 7, 2009 #5 Thanks, Jacob. Jacob Skaria said: Check out the below link to handle this and open outlook if not http://www.ozgrid.com/forum/showthread.php?t=73886 Click to expand...
Thanks, Jacob. Jacob Skaria said: Check out the below link to handle this and open outlook if not http://www.ozgrid.com/forum/showthread.php?t=73886 Click to expand...
