Re: Tools / Macro / Macros - which ones are these?

From: Sue Mosher [MVP-Outlook] (suemvp_at_outlookcode.com)
Date: 10/03/04


Date: Sun, 3 Oct 2004 15:31:28 -0400

So this is VBA? Does the code run OK if you run it from the VBA environment?
Does the subroutine have any arguments?

-- 
Sue Mosher, Outlook MVP
Author of
     Microsoft Outlook Programming - Jumpstart for
     Administrators, Power Users, and Developers
     http://www.outlookcode.com/jumpstart.aspx
"michaaal" <res0gyio@verizon.net> wrote in message 
news:eybFooWqEHA.3172@TK2MSFTNGP10.phx.gbl...
>
> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message
> news:elsuqBWqEHA.3876@TK2MSFTNGP15.phx.gbl...
>> I'm still wondering if you meant "VBA Sub" when you wrote "VB Sub"?
>>
>> Yes, you declare a subroutine public by putting Public in front of Sub.
>>
>> "michaaal" <res0gyio@verizon.net> wrote in message
>> news:OcO%23uZUqEHA.1576@TK2MSFTNGP12.phx.gbl...
>> > No I didn't declare it as Public.  It sounds like that may be my
> solution.
>> > How do I declare a sub as public?  I tried just putting "Public" in
> front
>> > of
>> > it, but this didn't seem to solve the problem.
>> >
>> >
>> >
>> > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message
>> > news:OLz8x4VpEHA.1816@TK2MSFTNGP09.phx.gbl...
>> >> Why would you expect a VB sub to show up in your VBA project? Or did
> you
>> >> mean "VBA sub"? Did you declare it Public?
>>     http://www.outlookcode.com/jumpstart.aspx
>> >>
>> >>
>> >> "michaaal" <res0gyio@verizon.net> wrote in message
>> >> news:%23$QEMQVpEHA.3688@TK2MSFTNGP09.phx.gbl...
>> >> > How can I get my newly created VB Sub to show up when I
>> >> > click Tools / Macro / Macros?
>> >> > (Outlook 2003)
>>
>>
>
>
> I apologize for not clarifying the difference.  Would you mind helping me
> out with this?  I can tell you exactly the steps I took to create the sub 
> if
> that helps?
>
> 


Relevant Pages

  • Re: determine encryption?
    ... It is very small and is the only one: Remember Outlook 2002 VBA not Outlook Express.: ... Public Sub TestMail ... This email and Outlook 2002 VBA are not on good terms. ... If I don't this encryption breaks VBA and so my script rule. ...
    (microsoft.public.security)
  • RE: Form, 3211 Error, could not lock table, already used in form.
    ... The forms recordsource had to be changed before that table could be ... > How to refresh a table shown on a form, when it is altered by a VBA ... > Private Sub Form_Load ... > ' Subroutine that shows 3211 Error, because table is shown in form? ...
    (microsoft.public.access.forms)
  • Re: Outlook 2k3: VBA will not start
    ... It should run, but you should also be testing basic VBA functionality with a simpler procedure, e.g. ... Sub Hello ... Another thing you can try is to export your code if you want to keep it, shut down Outlook, rename the VbaProject.otm file, then restart Outlook. ... It is just a simple MsgBox in the Application_Startup ...
    (microsoft.public.office.developer.outlook.vba)
  • Re: Outlook 2k3: VBA will not start
    ... What do I use to kick off this sub? ... Sue Mosher, Outlook MVP ... of the VBA kicked in. ... the code window and is still there when I restart. ...
    (microsoft.public.office.developer.outlook.vba)
  • AttachmentAdd Event
    ... I have copied the code in to the project as explained and closed the VBA ... In Microsoft Visual Basic Scripting Edition in an Outlook ... Private Sub newItem_AttachmentAdd(ByVal newAttachment As Attachment) ...
    (microsoft.public.outlook.program_vba)