Opening the Microsoft outlook 2007 from Excel VBA

[ThrottleWorks]

Hi,


Can anyone please provide me a code for opening the "Microsoft outlook 2007" from Excel VBA.


I have prepared a report, I need to provide a button to user if they want to send any mail regarding the reports.


Is it possible to open the outlook by using vba in excel.


Please help.

 

[dan_l]

Are you trying to open outlook or trying to start an email?

 

[ThrottleWorks]

Sir, I want to open the outlook, I do not want to start an email.


Thanks for looking into my query & trying to help me.

 

[dan_l]

shell("executable")


I think the executable is called outlook, but outlook sucks ass so I have no idea

 

[ThrottleWorks]

Sir, thanks a lot, it has worked. Many many thanks for your advice & time.