Sub or Function not defined when trying to run a VBA script in Outlook

Question

As a first step in creating a VBA script to resize a currently selected image to 100  x 100   I m trying to reproduce the example in http   msdn microsoft com en-us library ee814736 v office 14  aspx  The macro is very simple   Sub Test      MsgBox   Hello world   End Sub   The VBA script was simply created in  Project1  which opens by default when one presses Alt F11  However  I keep getting the error  Sub or Function not defined  when trying to run the VBA script  Figures 1 and 2    How can I make the VBA script  accessible  to Outlook    Figure 1  Running the  Test  macro in Microsoft Outlook   Figure 2   Sub or Function not defined  error  with module tree in the background

User · Accepted Answer

I solved the problem by following the instructions on msdn.microsoft.com more closely. There, it is stated that one must create the new macro by selecting Developer -> Macros, typing a new macro name, and clicking "Create". Creating the macro in this way, I was able to run it (see message box below).

enter image description here

User · Answer

I need to add that  if the Module name and the sub name is the same you have such issue   Consider change the Module name to mod Test instead of  Test  which is the same as the sub

User · Answer

I think you need to update your libraries so that your VBA code works  your using ms outlook

User · Answer

I had a similar situation with this issue  In this case it would have looked like this  Sub Test      MsqBox   Hello world   End Sub   The problem was  that I had a lot more code there and couldn t recognize  that there was a misspelling in  MsqBox   q instead of g  and therefore I had an error  it was really misleading  but since you can get on this error like that  maybe someone else will notice that it was cause by a misspelling like this

User · Answer

This error    Sub or Function not defined     will come every time when there is some compile error in script  so please check syntax again of your script   I guess that is why when you used msqbox instead of msgbox it throws the error

User · Answer

This probably does not answer your question  but I had the same question and it answered mine   I changed Private Function to Public Function and it worked

[vba] "Sub or Function not defined" when trying to run a VBA script in Outlook

Examples related to vba

Examples related to outlook