Distributing Outlook User Form

[utahjzz98]

I created a user form in Outlook using VBA and now I am looking to distribute this form to a couple different users. Unfortunately, I unable to find any documentation for how to accomplish this in Outlook. Can anybody enlighten me?

Thanks,
Corey

 

[combo]

Like in all VBA applications:
- export the userform, you get two files: FormName.frm and FormName.frx (VBE: right-click the userform in project explorer and choose export or, after selecting the userform icon File>Export file from menu)
- transfer both files to another user
- select project and import userform (the same way as export)
This does not copy project references.

combo

 

[utahjzz98]

I've developed VBA apps in Excel and Access before and usually I just distribute the .mdb or .xls files that already contain the VBA code and it works fine. This is the first time I have done a project in Outlook and wasn't quite sure how you distributed the app. I will give that a try, thanks for help.

Regards,
Corey

 

[combo]

Outlook vba project is in a separate file "VbaProject.otm", which is unique and linked to the user. I have not seen anything in the object model to access programmatically the vba project. So guess the way to extend Outlook are other COM add-ins or manual import of vba files.

combo

 

[utahjzz98]

I did a bit of research on what you said and it looks like the only way to distribute an Outlook VBA app is to create a COM object in Visual Basic 6.0 or C++. There isn't really any other way to distribute it other than copying the frm and .bas files like you recommended. Seems kind of silly that they even allow VBA to be supported in Outlook if there is no easy way to distribute it.

Thanks for the replies,
Corey