PDA

View Full Version : Open email template files based upon combo box values



jps8582
09-27-2011, 11:05 PM
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
09-28-2011, 04:27 AM
maybe...



Sub MakeItem()

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

End Sub

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