Solved

How can I get VB .NET to open and activate OUTLOOK.EXE?

Posted on 2010-09-03
10
1,168 Views
Last Modified: 2012-05-10
Hi,
I am currently creating a small application to display the contents of a user's inbox in Outlook. Double clicking the only window should open and activate Outlook.

All is working as expected when Outlook is actually open but if I close it or minimise it (despite the process still running in the background), I can't seen to get my application to make Outlook visible and make it the active window.

This code only works when Outlook is currently visible and behind other windows:

Declare Auto Function SetForegroundWindow Lib "USER32.DLL" _
        (ByVal hWnd As IntPtr) As Boolean

Declare Function SetActiveWindow Lib "USER32.DLL" (ByVal hwnd As Long) As Long


Dim Outlook() As Process = Process.GetProcessesByName("Outlook")

        If Outlook.Length > 0 Then
            SetActiveWindow(Outlook(0).MainWindowHandle)
            SetForegroundWindow(Outlook(0).MainWindowHandle)
            Return True
        Else
            Return False
        End If

I would appreciate help getting my form to open/activate Outlook in any circumstance.

Thanks.
0
Comment
Question by:milesryoung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
  • +1
10 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 33597124
VB is not my specialty, but can't you just use the shell() function:

http://msdn.microsoft.com/en-us/library/xe736fyk(VS.71).aspx
0
 
LVL 11

Expert Comment

by:ladarling
ID: 33597841
The Shell function is not .NET managed, use Process.Start:
System.Diagnostics.Process.Start("Outlook.exe")
 
0
 
LVL 11

Expert Comment

by:ladarling
ID: 33597889
If your application needs to 'own' that instance of outlook, you may want to declare it as a Process object in your app so that you can manipulate it for the eintire lifecycle of the outlook window:
http://msdn.microsoft.com/en-us/library/system.diagnostics.process.aspx
 
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 86

Accepted Solution

by:
Mike Tomlinson earned 250 total points
ID: 33598840
Try something like this:

    FocusApp("Outlook")

Using this code:
    Private Const SW_SHOWNORMAL As Integer = 1

    Private Declare Function IsIconic Lib "user32" (ByVal handle As Integer) As Integer
    Private Declare Function ShowWindow Lib "user32" (ByVal handle As IntPtr, ByVal nCmdShow As Integer) As Integer
    Private Declare Function SetForegroundWindow Lib "user32" (ByVal handle As IntPtr) As Integer

    Private Sub FocusApp(ByVal ExeName As String)
        Dim processes() As Process = Process.GetProcessesByName(ExeName)
        If processes.Length = 0 Then
            Process.Start(ExeName)
        Else
            ' Restore the window if it is minimized...
            If IsIconic(processes(0).MainWindowHandle) <> 0 Then
                ShowWindow(processes(0).MainWindowHandle, SW_SHOWNORMAL)
            End If

            ' Make it the foreground window...
            SetForegroundWindow(processes(0).MainWindowHandle)
        End If
    End Sub

Open in new window

0
 
LVL 11

Expert Comment

by:ladarling
ID: 33599153
@Idle: I wonder why they dont have a managed SetForeground method for the Process class? They obviously anticipated people wanting to interact with the app main window, why not add methods to do what we are trying to do. Cross-app communication hasnt really evolved much since the DDE concept, its kinda lame.
0
 
LVL 86

Expert Comment

by:Mike Tomlinson
ID: 33599286
I agree...they only went halfway with the legacy AppActivate() function:
http://msdn.microsoft.com/en-us/library/dyz95fhy(VS.80).aspx

    "The AppActivate function changes the focus to the named application or window but does not affect whether it is maximized or minimized."

I think part of the problem is that there are so many different libraries out there with controls/windows that don't support standard windows messages and then what constitutes a "window" keeps evolving...

...in WPF, for example, the "handle" of a window is hidden even deeper by default requiring even more work to obtain it.
0
 

Author Comment

by:milesryoung
ID: 33610506
Hi,

Thank you to all for your input. @Idle_Mind, I've tried your code but although it now works when Outlook is minimised, it still doesn't work if Outlook has been closed (although the process is still running).

In this case the SetForegroundWindow function gets "0" as the MainWindowHandle.
0
 
LVL 86

Expert Comment

by:Mike Tomlinson
ID: 33611635
"...it still doesn't work if Outlook has been closed (although the process is still running)."

Hmm...so when you "close" Outlook with the 'X' in the top right it stays in the background?

If you just run it again every time maybe it will bring up the main window?
0
 

Author Comment

by:milesryoung
ID: 33616028
Yes that's right. It is still a running process but the problem is with this line:

SetForegroundWindow(processes(0).MainWindowHandle)

...because Outlook has a MainWindowHandle of "0".
0
 

Author Closing Comment

by:milesryoung
ID: 33617109
I had to use the "Process.Start" in two places but otherwise this was a complete solution.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Find out what you should include to make the best professional email signature for your organization.
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question