Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Mar 2001
    Location
    Hampton, Virginia, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can I make Outlook XP stop protecting me from myse (Outlook 2002 (XP))

    New, apparently, in Outlook 2002 is the popup dialog that occurs whenever a macro tries to access the Outlook address book. I have written a VBA macro to insert commonly used addresses, e.g., "Home", "Me Here", etc., into the address field of email messages I compose. I access these from an "Addresses" menu item in the email form. This all worked fine in Outlook 2000. Now that I have migrated from Outlook 2000 to Outlook XP, whenever I use one of these addresses I must click a button in a popup that says "A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this?" Of course I want to allow this, Dummkopf, I write the macro didn't I? I even digitally signed the silly thing.

    Does anyone know how to make this stop happening, at least for digitally signed macro projects? I tried looking on Sue Mosher's site (http://www.slipstick.com/), but failed to see this problem addressed. Maybe I just missed it.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can I make Outlook XP stop protecting me from myse (Outlook 2002 (XP))

    Take a look at http://groups.google.nl/groups?hl=en&lr=&i...16@TK2MSFTNGP09 for some suggestions from Sue Mosher.

  3. #3
    Lounger
    Join Date
    Mar 2001
    Location
    Hampton, Virginia, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can I make Outlook XP stop protecting me from myse (Outlook 2002 (XP))

    Hans,

    Many thanks for your quick response. The URL didn't actually work (I tried it both IE6 and Mozilla 1.3) - in both cases it took me to Google Groups but displayed no content. However, you gave me the essential idea, and searching Google Groups for "mosher outlook allow access e-mail addresses" took me right where I needed to go.

    Unfortunately, what Sue's telling me isn't what I want to hear, but that's Microsoft's fault, not yours or hers. I was trying to avoid a SendKeys solution since resorting to that always feels like defeat, but it looks as though that's the only viable way to go (sigh). Life is cruel.

    Regards,

    John.

  4. #4
    Lounger
    Join Date
    Mar 2001
    Location
    Hampton, Virginia, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can I make ... (Follow-up)

    Hans,

    I downloaded and installed Express ClickYes 1.0.4 (http://www.express-soft.com/mailmate/clickyes.html), one of the alternatives mentioned by Sue Mosher, even though one of her respondents said it trashed his system (Win XP). I'm using Win2K and, for safety, I checked it out first on an expendable laptop with no problems. What the program does is to press "Yes" for you - not all that elegant but acceptable.

    My reasons for posting this include:
    1) It works like a champ (for me, at least)
    2) It's free
    3) This latest version can be turned on/off from a VBA macro - thus I can have the protection of Microsoft's big brother running at all times, but use ClickYes to respond to the prompt for me when I want it to.

    Just thought other Loungers might want to know about this. Thanks again for your help.

    Regards,

    John.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can I make Outlook XP stop protecting me from myse (Outlook 2002 (XP))

    The link I provided apparently expired. I will post the text here, with the explicit mention that it was written by MVP Sue Mosher in a reply to a question in the microsoft.public.office.developer.outlook.vba newsgroup:
    <hr>The security dialogs that pop up when an application tries to access certain Outlook properties and methods are designed to inhibit the spread of viruses via Outlook; see http://www.slipstick.com/outlook/esecup.htm#autosec.

    If you are a standalone user, Outlook provides no way to suppress this behavior. However, you can use a free tool called Express ClickYes (http://www.express-soft.com/mailmate/clickyes.html) to click the security dialog buttons automatically. Beware that this means if a virus tries to send mail using Outlook or gain access to your address book, it will succeed.

    If you're the administrator in an Exchange Server environment, you can reduce the impact of the security prompts with administrative tools. See http://www.slipstick.com/outlook/esecup/admin.htm.

    If it's an application you wrote yourself, you can use one of these approaches to redo the program:
    -- Use Extended MAPI (see http://www.slipstick.com/dev/mapi.htm) and C++ or Delphi; this is the most secure method and the only one that Microsoft recommendeds.
    -- Use Redemption (http://www.dimastr.com/redemption), a third-party COM library that wraps around Extended MAPI but parallels the Outlook Object Model
    -- Use SendKeys to "click" the buttons on the security dialogs that your application may trigger. See http://www.slipstick.com/outlook/esecup.htm#autosec for a link to sample code.
    -- Program the free Express ClickYes (http://www.express-soft.com/mailmate/clickyes.html) tool to start suspended and turn it on only when your program needs to have the buttons clicked automatically.<hr>
    HTH

  6. #6
    Star Lounger
    Join Date
    Feb 2003
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can I make Outlook XP stop protecting me from myse (Outlook 2002 (XP))

    Now everyone has depressed you with all these facts about what is going wrong, take heart, John - there is an easy solution to your problem.

    Don't use the address book every time. Periodically - like once a month or something - "dump" data from your address book to a - say - XML file (or just a text file or registry entries - however you like to work): when this code runs you will get the popup. Change the code that inserts the address to take it from this source, not the address book. Voila.

  7. #7
    Lounger
    Join Date
    Mar 2001
    Location
    Hampton, Virginia, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can I make Outlook XP stop protecting me from myse (Outlook 2002 (XP))

    Steve,

    Actually, I'm not really accessing the address book when I get the popup - I'm was accessing the To: field of the current message thus:
    s = myInspector.CurrentItem.To
    However, my problem has now been solved by a little program called "Express ClickYes" which presses the "yes" button for me. Thanks for your response.

    Regards,

    John.

Posting Permissions

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