Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi everybody:

    I'm used to using Office 2002/3 and have just been "upgraded" to Office 2007.
    Need to automate sending some emails, but rather than try rewriting my old VBA code for Office 2007, thought I'd try the mail merge utility.

    I set Outlook security to the lowest level, enabled macros, and added my merge file path as a trusted location, but every time Office created a new mail item, I got a nasty popup warning me about security and requiring that I click on its silly button. It took 20 minutes to send out 9 very simple, brief emails.

    Anybody know how to work around this?

    Thank you, in advance, for your help.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by kriss669 View Post
    I set Outlook security to the lowest level, enabled macros, and added my merge file path as a trusted location, but every time Office created a new mail item, I got a nasty popup warning me about security and requiring that I click on its silly button. It took 20 minutes to send out 9 very simple, brief emails.
    I think this is normal for mail merges. In older versions of Office, you may recall that the permission dialog let you set a time, e.g., 5 minutes, during which you would not be prompted again for access by the same program. Is that still an option in Outlook 2007? Or is it not working?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by jscher2000 View Post
    I think this is normal for mail merges. In older versions of Office, you may recall that the permission dialog let you set a time, e.g., 5 minutes, during which you would not be prompted again for access by the same program. Is that still an option in Outlook 2007? Or is it not working?
    Theoretically, it is an option; however, selecting 10 minutes has no effect and even if it did, the utility is so slow that it would still be useless.

  4. #4
    New Lounger
    Join Date
    Dec 2009
    Location
    Redmond WA
    Posts
    14
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi there,
    Just joined and don't know if you have resolved this. I use the redemption package to programatically avoid the Outlook security messages.
    http://www.dimastr.com/redemption/
    Great for all the Access databases I write.
    Cheers.
    Willie McClure
    www.datarim.com

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    A simpler approach than Redemption (but not as elegant) is to install ClickYes.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    3 Star Lounger
    Join Date
    Dec 2009
    Location
    Sydney, Australia
    Posts
    254
    Thanks
    0
    Thanked 5 Times in 5 Posts
    Kriss669 I feel your pain,

    I have a few clients which have varying ways of dealing with this including ClickYes. But an application/plugin I am yet to try but have been meaning to is Advanced Security for Outlook by MAPILab.

    http://www.mapilab.com/outlook/security/

    I'm going to trial it out in a virtual environment as I do with most things and see how it runs as it says it runs on pretty much all incarnations of MS Office and Windows OS. Including being Free for commercial and non-commercial use.

    Has anyone used/trialed this?

    P.S. Thanks for the link to redemption Willie McClure. I intend to pass it on to some small Access developers I know

Posting Permissions

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