Learn Excel - Video 537 - VBA - Export outlook body content in Excel
How to use a userform and combo box to select from a list of subjects when creating an email message in Outlook. You can also use it to select from a list of templates or macros.
http://www.slipstick.com/outlook-developer/code-samples/vba-userform-sample-select-list-templates/