Export custom pull-down menu from Outlook?

exceldemon

New Member
Joined
Jun 30, 2010
Messages
38
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?
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,784
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
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

New Member
Joined
Jun 30, 2010
Messages
38
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

Well-known Member
Joined
Feb 24, 2003
Messages
1,784
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
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

Well-known Member
Joined
Feb 24, 2003
Messages
1,784
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
here is my code to read the file

Code:
'****
' 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

Code:
;****
; 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
 

Watch MrExcel Video

Forum statistics

Threads
1,127,334
Messages
5,624,089
Members
416,010
Latest member
NJT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top