Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Annoying Outlook Warning (XP)

    I have vba coding in Excel which will send out a weekly report to a number of people. It works fine, but there is the annoying problem of Outlook giving the message about a program trying to send an email, it could be a virus, blah, blah, blah. Click Yes if you want to continue. Is there anyway to stop the message from happening?
    I created the vba so I know it is not a virus.

    Thanks.

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Annoying Outlook Warning (XP)

    Like the message in <post:=507,596>post 507,596</post:>?

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Annoying Outlook Warning (XP)

    Yes that is the message. Have read about ClickYes and if this is the only alternative then I am out of luck. Can't just install programs on government systems. That is why I was looking for a way to shut it off.

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

    Re: Annoying Outlook Warning (XP)

    There's a link in the same thread to a post that mentions other options. In summary:
    <UL><LI>If you use Outlook with Exchange Server, the Exchange administrator can remove the restriction selectively: see Administrative Options for the Outlook E-mail Security Update.
    <LI>You can rewrite your code to use Extended MAPI. Since this can't be scripted, it doesn't need the draconic security measures. You can download a COM add-in that provides a wrapper about Extended MAPI: Outlook Redemption. It is free for development use; if you want to distribute it, you need a license.[/list](From: <post:=488,173>post 488,173</post:>)

    If you're not allowed to install Outlook Redemption either, getting your Exchange admin to lift the restriction is your only option. Otherwse, you'll have to live with it.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Annoying Outlook Warning (XP)

    Thanks. Guess I am stuck.

  6. #6
    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: Annoying Outlook Warning (XP)

    I'm sure ClickYes uses the Windows API to detect the dialog that needs to be clicked. Perhaps someone has posted the code for that so you could incorporate it into your workbook.

Posting Permissions

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