Don't "see" my macro when I try to run it

JoeLiuzzo · Joined: 27 Feb 2008 Posts: 2

Writing my first VBA for Outlook 2003, although I have written many for
EXCEL. I created the macro and saved VBAProhect.OTM, but then when I return
to Outlook and choose Tools|Macro|Macros.., there are no entries and
everything is diabled except 'Cancel'. If I type the name in the text box,
then the "Create" command is enabled & when I click it, I am brought to the
VBA_Editor with my pre-existing code sitting there and the shell of a new
function below it.
What's the magic action that has to happen to get the coded macros to be
available to the Outlook app?
thanks

Archived from group: microsoft>public>outlook>program_vba

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

Did you in fact create a macro -- an argumentless public subroutine -- and not some other kind of procedure?

Also, if you created a new module, use a different name for the procedures in that module. I've heard of some problems when module and procedure name are the same.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"JoeLiuzzo" wrote in message @microsoft.com...
> Writing my first VBA for Outlook 2003, although I have written many for
> EXCEL. I created the macro and saved VBAProhect.OTM, but then when I return
> to Outlook and choose Tools|Macro|Macros.., there are no entries and
> everything is diabled except 'Cancel'. If I type the name in the text box,
> then the "Create" command is enabled & when I click it, I am brought to the
> VBA_Editor with my pre-existing code sitting there and the shell of a new
> function below it.
> What's the magic action that has to happen to get the coded macros to be
> available to the Outlook app?
> thanks

JoeLiuzzo · Joined: 27 Feb 2008 Posts: 2

No, I guess I did not. I was basing my code on a snippet I found here in the
forum and it has an argument, as in MyCode(Item As Outlook.MailItem). If
that's not a macro, then what is it? Bottom line is I'm trying to code
something I can execute from the "run a script" option of the Outlook rules.
Am I barking up the wrong tree? Am I even in the forest? Smile

"Sue Mosher [MVP-Outlook]" wrote:

> Did you in fact create a macro -- an argumentless public subroutine -- and not some other kind of procedure?
>
> Also, if you created a new module, use a different name for the procedures in that module. I've heard of some problems when module and procedure name are the same.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "JoeLiuzzo" wrote in message @microsoft.com...
> > Writing my first VBA for Outlook 2003, although I have written many for
> > EXCEL. I created the macro and saved VBAProhect.OTM, but then when I return
> > to Outlook and choose Tools|Macro|Macros.., there are no entries and
> > everything is diabled except 'Cancel'. If I type the name in the text box,
> > then the "Create" command is enabled & when I click it, I am brought to the
> > VBA_Editor with my pre-existing code sitting there and the shell of a new
> > function below it.
> > What's the magic action that has to happen to get the coded macros to be
> > available to the Outlook app?
> > thanks
>

Way to add prompt to this macro? Hi! I was given a fantastic script on this board some time back which I use all the time. It sorts the folders in the main Personal Folders. This is the script here: Private Sub Applicati

Paste Special Macro What is a macro for "Past Special Unformatted Text" that I can put on the Tool bar? How can I assign a shortcut key to it? Thanks for any advice! I'm trying to duplicate the macros that I have in Word and Excel that perform the same task.

Macro Execution Pardon my second post, but my first received no response. I am a newbie to vba, but managed to create a macro that works when run manually, I would like the macro to run automatically on the send_item event, or some other event, but I am having trouble

Possible Macro Request I was wondering if there were someone here that would be willing to create a small custom macro for me so that I can use it as a rule within Outlook 2003? Or am I in trouble now for asking this because I shouldn't be? If not then I'll add that I'd entert

The macro cannot be found Hello, Help is needed for the following problem: I wrote some VBA code in Outlook 2003. when I tried to run it from within Outlook by clicking a customized macro button on the toolbar, I received an error message that said "The xxx macro cannot be found".