Export custom pull-down menu from Outlook?

[exceldemon]

I created a custom menu in Outlook (Customize->NewMenu) and added a number of buttons that opens various standard forms.

Does anyone know how I could easily add this custom menu to my coworkers computers instead of having them create the menu manually?

 

[jimrward]

if this is a like a custom toolbar, try the following, locate the source folder on your computer that holds a file called outcmd.txt, try searching for it in C:\Documents and Settings\<yourname>\Application Data\Microsoft\Outlook

close down outlook, copy the file to a stick, and place it in the same folder on a co worker, start up outlook on co workers machine and see if it includes the new menu

if it does not work it might be another file in the same folder that needs copying, I know that outcmd.txt works for command bars

 

[exceldemon]

if this is a like a custom toolbar, try the following, locate the source folder on your computer that holds a file called outcmd.txt, try searching for it in C:\Documents and Settings\<yourname>\Application Data\Microsoft\Outlook

close down outlook, copy the file to a stick, and place it in the same folder on a co worker, start up outlook on co workers machine and see if it includes the new menu

if it does not work it might be another file in the same folder that needs copying, I know that outcmd.txt works for command bars

Yea, that would work but it also removes any custom toolbars the other person has, including the layout.

 

[jimrward]

unfortunately there is no way to merge the file, even though it has a txt extension its a microsoft binary of some type, in their wisdom microsoft thought this to be sensible, only other option is to email all some code to slip into a module and run once

i ran into the same problem and ended up with my own text file to describe the buttons i wanted along with icons etc etc and had some code to read the file and set it up

 

[jimrward]

here is my code to read the file

'****
' procedure to create a toolbar and fill it from an external text file
' this should speed up the process when toolbar names are changed
'
' Author        Jim Ward
' Creation      15th June 2011
'
'****
'
Private Sub ToolBarSetup3()
Dim objsubmenu As Object
Dim cbName As String

Open "C:\Menu setup.txt" For Input As #1

While Not EOF(1)
    Line Input #1, wholeline
    If Left(wholeline, 1) <> ";" Then
        If InStr(wholeline, ",") = 0 Then
            cbName = wholeline
            On Error Resume Next
            Application.ActiveExplorer.CommandBars(cbName).Delete
            Application.ActiveExplorer.CommandBars.Add(Name:=cbName, Position:=msoBarTop).Visible = True
            Application.ActiveExplorer.CommandBars(cbName).Enabled = True
            Application.ActiveExplorer.CommandBars(cbName).Visible = True
            Set objsubmenu = Application.ActiveExplorer.CommandBars(cbName)
        Else
            With objsubmenu
                CaptionOnActionFace = Split(wholeline, ",")
                With .Controls.Add(Type:=msoControlButton)
                     .Caption = CaptionOnActionFace(0)
                     .OnAction = "Project1." & CaptionOnActionFace(1)
                     If CaptionOnActionFace(2) <> "-1" Then
                        .FaceId = CaptionOnActionFace(2)
                        .Style = msoButtonIconAndCaption
                     End If
                End With
            End With
        End If
    End If
Wend
   
Close #1

End Sub

and here is the text file to drive it, might give you some ideas, last entry is a button to drive the macro above

;****
; this is a setup file for the outlook letter macros for changing the button names
; or macro names.
;
; This is used to drive the build menu bar macro
;
; leave the format as is and modify as required when you change the names
; or add in new macros or delete old ones
;
; Creation		20th June 2011
; Author		Jim Ward
;
; Any comments start the line with a semi colon, these will be ignored by the macro
;
; format is
;
; <toolbarname>
; 
; <buttonname>,<macroname>,<iconid>
;
;****
; ToolBar Name, you should never need to change this once setup
; it is used to delete the current toolbar and set up new one
;*****
;
Letters
;
;****
; and now the buttons with the associated macro name and icon if required
;
; <iconid> -1 : leave as name only
;           0 : leave a space to space out icons
;          31 : pencil icon
;          52 : pig
;          59 : smiley face
;         266 : fox face
;         276 : unhappy face
;         609 : another animal
;****
;
ST6,emailletterST6,-1
ST16,emailletterST16,-1
ST17a,emailletterST17a,-1
ST37,emailletterST37,-1
ST45a,emailletterST45a,-1
ST54,emailletterST54,-1
IndRef,emailletterIndRef,-1
NonResident,emailletterNonResident,266
ReqCopyAllCorres,emailletterReqCopyAllCorres,-1
CopyEmail,emailletterCopyEmail,-1
Agent,emailletterAgent,-1
DoMenu,ToolBarSetup3,59