Open email template files based upon combo box values

[jps8582]

I'm looking for assistance on how I can launch MS Outlook OFT files when selecting a value within my combo box?? In this particular example I'm looking to setup a drop down list (combo box) with only a few options, each of which would launch a different OFT file so the end user could easily email from their MS Excel workbook. Is this possible?

[mancubus]

maybe...

[VBA]Sub MakeItem()

Set newItem = Application.CreateItemFromTemplate("c:\your path\open test.oft")
newItem.Display
Set newItem = Nothing

End Sub
[/VBA]
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54