none
Outlook custom forms - Use existing forms and struggle with VB Script vs. Build in VBA and love life RRS feed

  • Question

  • Hi all,

    I would appreciate your thoughts with regard to the benefits and drawbacks of building Outlook custom forms in VBA vs. using existing forms and having to work with VB script.  I have built a custom form and am really struggling with getting the script to work properly.

    Thanks,

    Gary

    Wednesday, May 2, 2012 12:56 PM

Answers

  • The only code that will run in Outlook custom forms is VBScript code. VBA code is used for macros and prototyping.
     
    You can design dialogs in VBA but Outlook VBA is not intended for deployment to other machines, so if you want your forms to be available to others VBA would not be recommended.
     
    You don't mention your Outlook version. If it's Outlook 2007 or later the recommended approach to customizing the user interface of forms is to use Form Regions along with a COM addin to add business logic and work with the Form Regions.

    --
    Ken Slovak
    [MVP - Outlook]
    http://www.slovaktech.com
    Author: Professional Programming Outlook 2007
    Reminder Manager, Extended Reminders, Attachment Options
    http://www.slovaktech.com/products.htm
     
     
    "Dusty458" <=?utf-8?B?RHVzdHk0NTg=?=> wrote in message news:5b761895-5b4b-4c31-82cf-19378bf9880a...

    Hi all,

    I would appreciate your thoughts with regard to the benefits and drawbacks of building Outlook custom forms in VBA vs. using existing forms and having to work with VB script.  I have built a custom form and am really struggling with getting the script to work properly.

    Thanks,

    Gary


    Ken Slovak MVP - Outlook
    Wednesday, May 2, 2012 2:38 PM
    Moderator