Results 1 to 13 of 13
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Kalgoorlie, Western Australia, Australia
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outlook Security Levels and Macros (2000 SP1)

    When I run a macro I have created using the VB Editor, Outlook warns me no matter what security levels I use. Even when I sign the macro with a digital signature using SelfCert.exe. Can anyone help me, I want to not be warned when I run a signed macro.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    in tools | macro | security set security to medium after signing the macro. close outlook and reopen. open the vbe and you should be presented with the enable/disable macro dialog. check always trust and then clcik enable macros.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Kalgoorlie, Western Australia, Australia
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Mary

    Thanks, this has helped quite a bit. I followed your instructions and the enable/disable macro dialog came up and everything but when I click my toolbar button that runs the macro the attached warning still appears.

    Usually this appears when I run the macro and when I open the form I created with the macro. However, now if I open the journal entry which the macro created it doesn't give me the warning. This is a step forward but I would appreciate any more tips you (or anyone) has to offer.

    Thanks for your help so far.
    Attached Images Attached Images

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    oh - it's scripts not vba... is the form published? Are you including the form definiation? (don't) Publishing the form should stop it completely, unless you include the form defination.

  5. #5
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Kalgoorlie, Western Australia, Australia
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Mary

    I am running this Macro to create the journal item and show a VBE form which sends data to the journal item.

    <pre>Sub NHM_Create()
    Set myOlApp = CreateObject("Outlook.Application")
    Set NHMItem = myOlApp.CreateItemFromTemplate _
    ("C:WINDOWSProfilesMelissaApplication DataMicrosoftTemplatesNHM Journal.oft")
    NHMItem.ContactNames = "New Horizon Ministries"
    frmSelect.Show
    End Sub
    </pre>


    I have published the form (without sending the form definition), but the message still appears when I run the macro. Do you think the problem is that I am using it from a template? How do I access the form otherwise?


    Thanks

  6. #6
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    yes, i'm pretty sure it's the template - publishing stops vba warnings - i know it does scripts.

    tools > publish form (going from memory on the location, i'm in word mail and can't check [img]/forums/images/smilies/sad.gif[/img])

    i recommend publishing it to a folder (not a forms library)- then load it using the actions menu when in that folder.

  7. #7
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Kalgoorlie, Western Australia, Australia
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Mary

    I have been saving the form in the Journal folder and I can run it from the menu. I have created the macro to add functionality I couldn't work out how to do in the Script Editor (which is not much more than a text box).

    Do you know how I can create the journal item from an Outlook folder rather than a template in the VB Editor?

    Do you know how I can delete forms from my folder? Now I have got NHMJournal and NHM Journal on the actions Menu as I published copies with different names.

    Thanks

  8. #8
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Maybe this will help:

    You manage form from Tools | Options | Other Tab; Advanced btn; Custom Forms btn; Manage Forms btn.

    This code assumes you put the form in the Inbox and it's a note (message). You'll want to replace "formname" with the name of your form.

    Set myfolder = Session.GetDefaultFolder(olFolderInBox)
    Set myitem = myfolder.Items.Add("ipm.note.formname")

  9. #9
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Kalgoorlie, Western Australia, Australia
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Thanks OldDog

    I'll try the code.
    <img src=/w3timages/blackline.gif width=33% height=2>
    You manage form from Tools | Options | Other Tab; Advanced btn; Custom Forms btn; Manage Forms btn.
    <img src=/w3timages/blackline.gif width=33% height=2>
    This is what the help said but there is no custom forms button on my copy of Outlook (it is on a stand alone computer if that makes any difference)

  10. #10
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Hmm. I've never run across that before. I have a stand alone at home and will take a look. Could it be something to do with installed options?

  11. #11
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    you have internet mail only mode. it doesn't offer forms management.

    one good option - change to corp mode temperarily

    several hacks - copy the pst to a computer using outlook in corp mode or use outlook spy to rummange around and find the forms.

    for future reference - forms are stored in the folder they are published to - so if they are in a folder you added, delete the folder. (move the messages in it to a new folder and republish the forms you want to keep to the new folder)

  12. #12
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Kalgoorlie, Western Australia, Australia
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    How do you change to corporate mode? I've looked in the help and it says to goto Tools ->Services, but I don't have the services option.
    <font face="Script MT Bold">Edited post a few minutes later:</font face=script> <font color=red>I found it - under Tools, Options, Mail Delivery, Reconfigure mail services. I have now successfully deleted the form. Hooray! </font color=red>

    Where can I get Outlook Spy?

    Thanks for your help

  13. #13
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Outlook Security Levels and Macros (2000 SP1)

    Outlook Spy lives here: <A target="_blank" HREF=http://www.dimastr.com/>http://www.dimastr.com/</A>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •