CODEWITHSUNDEEP
excelvbaoutlook
user7465381
user7465381

Reputation:

Edit and Send Outlook Form Template From Excel VBA

Currently, I have the Excel VBA code that will construct and send an Outlook email from Excel. However, I need to be able to use this VBA to open an Outlook form template that contains a command button and update the body of the message. I have been searching non-stop and cant find any good resources for accomplishing this, any good pointers, links, or supporting code would be greatly appreciated. Thanks.

Upvotes: 0

Views: 1835

Answers (1)

Eugene Astafiev
Eugene Astafiev

Reputation: 49395

You can save the form as a Microsoft Outlook template file (.oft), and then e-mail that file to users. If the form contains code or custom fields, the recipient will not be able to simply open the .oft file and publish it. The recipient will need to save the .oft file to the local drive, run it with the Tools | Forms | Choose Form command, and then publish the form to the Personal Forms Library.

Alternatively, you can use an .fdm file to install a form manually, see OL2000: How to Move a Custom Form to Another Computer.

Read more about Outlook forms in the To distribute Microsoft Outlook forms to other users article.

As a workaround you may consider creating a COM add-in with rich UI options which can be installed on the recipient's side and do whatever you need for users. See Walkthrough: Create your first VSTO Add-in for Outlook for more information.

Upvotes: 0

Related Questions