Opening & minimizing Outlook from Excel

[trevolly]

Hi all,

Because our PC's at work are quite slow, I've written a v small piece of vba code so that when a colleague opens a specific form excel opens Outlook and displays a specific worksheet as the excel workbook opens. This means Outlook can load up whilst the excel form is being completed. This code works perfectly but I was wondering if anyone knows any vba code they could add that minimizes Outlook immediately as it opens ?

The vba code is placed in the "This Workbook" area of the workbook. I'm sorry I'm not using "XL2BB" but I'm not allowed to install it on my work laptop.

"Private Sub Workbook_Open()

Shell ("OUTLOOK")
Worksheets("Birdstrike").Activate
Range("F6:J6").Select
End Sub"


Appreciate all you help.
Trevor

 

[Micron]

Amazing how many people have asked for this for the last 15 years and so many dead ends when researching and so many solutions that reportedly didn't work. After about an hour of piecing together ideas I came up with this (use your outlook.exe path). You need a reference to Microsoft Scripting Runtime IIRC.

Dim ofSO As Object

Set ofSO = CreateObject("WScript.Shell")
ofSO.Run """C:\Program Files (x86)\Microsoft Office\root\Office16\OUTLOOK.EXE""", 7, False

Worksheets("D").Activate
Range("F6:J6").Select

You will may see the Outlook splash screen with some other number than 7 but I don't if I use 7.
If you click on outlook icon in task bar, you will maximize Outlook though. Running this from the vb editor I find that the sheet isn't activated so that may need tweaking. Perhaps it will for you if you run that from Excel wb and not the editor. I didn't try.

 

[trevolly]

Thank you for spending the time looking in to this @Micron. I didn’t realise it was a difficult process. I’m going to play with the code you’ve provided.