This would open outlook:
Dim outlookApp As Outlook.Application
' create Outlook session
Set outlookApp = GetOutlookApp
I'm not sure about closing.
For some Excel sample code, see
http://www.jpsoftwaretech.com/excel-vba/send-email-from-excel/. It's all for sending email, but the same basic steps are used to create appointments or contacts.