Posting a UserForm to a Public Folder

[London Developer]

Hi,

Basically, I've created a User From in VBA and would like to post it to a
public folder.

Can this be done from VBA code? Any advice / pointers really appreciated!

Thanks

 

[Sue Mosher [MVP]]

No. VBA userforms are not the same as Outlook forms (i.e. templates for displaying Outlook data). You would need to create an Outlook form if you want to post data to a public folder.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

 

[London Developer]

Okay, thanks for clearing that up.

I'm assuming that Outlook forms are limited to VB Script as opposed to VBA?
Is there an article that compares the differences between them, or, do most
people stick with customising the Outlook forms? They seem tricky to
customise if you have to rely on script, as opposed to a typed-language like
VBA?


No. VBA userforms are not the same as Outlook forms (i.e. templates for
displaying Outlook data). You would need to create an Outlook form if you
want to post data to a public folder.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

 

[Sue Mosher [MVP]]

What a lot of us do is prototype and test the form code in VBA, then remove the data typing and add constant declarations to move it to the VBScript environment of the form. MSDN has documents on what functions work in VBA vs. VBScript. The one I miss the most is Format().
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm