VBOffice

Open Custom Form via your own Ribbon

With a button for your templates you can open them with less clicks.

Last modified: 2010/10/13 | Accessed: 64.187  | #85
◀ Previous sample Next sample ▶
Reporter Reporter
VBOffice Reporter is an easy to use tool for data analysis and reporting in Outlook. A single click, for instance, allows you to see the number of hours planned for meetings the next month.

In Outlook 2010 you can create your own tab on the ribbon with commands to call VBA functions.

First copy the code into the module ThisOutlookSession. This VBA sample creates a new item in the current folder and uses a custom form named ipm.note.my_test.

How to create the tab: Click File/Options, then Customize Ribbon. Click New Tab, and rename the tab and group if you like. Now select Macros from the Choose commands from listbox. Select the macro and click the Add button


tip  How to add macros to Outlook
Public Sub AddMyForm()
  Dim Items as Outlook.Items
  Dim Item as Object
  Set Items=Application.ActiveExplorer.CurrentFolder.Items
  Set Item=Items.Add("ipm.note.my_test")
  Item.Display
End Sub
OLKeeper OLKeeper
OLKeeper reliably prevents users from closing their Outlook window and thus possibly missing reminders or e-mails.
email  Send a message