Open Outlook from excel commandbutton

[zplugger]

Looking for a way to open outlook in minimized state with excel commandbutton? seems like all the code for email put the email in outbox,and will not send.

Thanks Z

 

[zplugger]

This will open outlook,now just need for it to be minimized.

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

 

[zplugger]

Looking for help here too
Open oulook from excel

 

[James Snyder]

What about bypassing Outlook and sending it directly? Look at using CDO...
Sending mail from Excel with CDO

 

[zplugger]

So what your saying, it is not possible?

 

[James Snyder]

No, it might be, but that is not my area of experience to be able to help. I use CDO to bypass Outlook because I am sending text files and spreadsheets, but Excel/Outlook can only handle Microsoft file formats. Maybe someone else will chime in with a direct answer to your question...

EDIT:
Outlook advantages:
• have an audit trail in your sent mail
• can directly access Outlook features such as signatures, out box
• doesn't require a reference, therefor is more portable from desktop to desktop

CDO advantages:
• low memory footprint since it is not adding an app to the process
• can send any file type
• quick
• no application issues to deal with