There are many companies and Web-based services that allow you to create templates for HTML e-mails. After using one for some time, you may feel the desire to switch to Microsoft Outlook for your e-mail delivery needs. However, if you are happy with the template you have created, you may want to bring it into Outlook as an OFT file for use in later mailings. Fortunately, through the use of an Outlook VBA module, you can easily convert an HTML file to an Outlook template.

  • There are many companies and Web-based services that allow you to create templates for HTML e-mails.
  • However, if you are happy with the template you have created, you may want to bring it into Outlook as an OFT file for use in later mailings.

Save your HTML e-mail template and all dependent files to your local drive.

Start Microsoft Outlook and hit "ALT+F11" to bring up the Visual Basic editor. Select "Insert" and "Module" from the main navigational menu.

Copy and paste the following code into your blank module:

Sub MakeHTMLMsg()


              Set objMsg = Application.CreateItem(olMailItem)

Set fso = CreateObject("Scripting.FileSystemObject")

Set ts = fso.OpenTextFile("c:\testfile.htm", 1)

strText = ts.ReadAll

objMsg.HTMLBody = strText

objMsg.Display

Set fso = Nothing

Set ts = Nothing

Set objMsg = Nothing
            

End Sub

Substitute the complete local path to your HTML file for the parameter of "OpenTextFile."

Close the Visual Basic editor and run the macro you just created by hitting "ALT+11" in the Outlook window to bring up the macro window. Select "MakeHTMLMsg" from the list of macros and click the "Run" button to bring up your HTML template in an Outlook message.

  • Copy and paste the following code into your blank module: Sub MakeHTMLMsg() End Sub Substitute the complete local path to your HTML file for the parameter of "OpenTextFile."
  • Select "MakeHTMLMsg" from the list of macros and click the "Run" button to bring up your HTML template in an Outlook message.

Select "File" and "Save As" from the navigational menu of your HTML template in Outlook to save your message as an OFT file.