Open oulook from excel

zplugger · Oct 1st 2013

Trying to find a way to open outlook from excel commandbutton. Found a way to open outlook,but want it to be minimized.
This will open outlook,now just need for it to be minimized.

Code

Private Sub CommandButton1_Click()
Shell ("OUTLOOK")
End Sub

http://www.mrexcel.com/forum/e…-excel-commandbutton.html

not having much luck.

Z

cytop · Oct 1st 2013

Re: Open oulook from excel

Try reading the Help file for SHELL..., especially the available parameters.

To keep your post on MrExcel compliant with the rules there (same rule exists here, BTW), you should update that thread with a link to this one.

zplugger · Oct 1st 2013

Re: Open oulook from excel

I see where =2 is minimized but not sure how to write code.

cytop · Oct 1st 2013

Re: Open oulook from excel

Code

Shell "OUTLOOK", 2

You need to lose the ()'s.

zplugger · Oct 1st 2013

Re: Open oulook from excel

It still opens outlook full size?

cytop · Oct 2nd 2013

Re: Open oulook from excel

Not for me - although using 6 instead of 2 (which is supposed to start Outlook minimised, no focus), actually displays Outlook; however,using 2 starts Outlook minimised, with focus.

Sorry, can't help futher as I cannot replicate your issue.

Open oulook from excel

Participate now!

Share