Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Operations Error

    I have code in Access that grabs 50 email addresses and sends them to a new Outlook message for a bulk email. This has worked flawlessly for nearly 4 years. However the user has just upgraded to Exchange Server 2003 SP2. Ever since that upgrade, after the code opens Outlook at a new message, with all the addressees in the BCC field, they get the error
    Regards,
    Peter

  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

    Re: Operations Error

    Are you using Access's SendMail method or are you automating Outlook? Using Redemption to work around security prompts or a signed DLL?

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Operations Error

    I have no idea what redemption is.
    Here is most of the code that opens Outlook and fills the message
    Regards,
    Peter

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

    Re: Operations Error

    FYI: Outlook Redemption is a library that can be used when automating Outlook to avoid the security warnings you get when you manipulate Outlook in code.

  5. #5
    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: Operations Error

    The user sees the message with the address fields populated, and then gets the error? The above snippet does not appear to be causing the error, because after the address fields are populated, the only remaining code is:

    <code> .Display
    End With
    Exit_cmdMergeToEMailSingle_Click:
    On Error Resume Next
    Set olMsg = Nothing: Set appOutlook = Nothing
    Exit Sub</code>

    How about the contacts being selected? I wonder whether one might be a distribution list that behaves differently in an Exchange 2003 environment.

    Added: Perhaps it would help to insert a Stop command or set a break in the part of the code that creates the Outlook message and see whether you can determine where the problem is by stepping through the code. Sometimes this eliminates the error by working around a hard-to-diagnose timing problem.

    Added: One other thought. I use a methods similar to "logon" and "logoff" when working with Outlook, for reasons that I can't remember. You could look those up and see whether they help.

  6. #6
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Operations Error

    Thanks Hans, really apreciated. The IT guy made an adjustment to LDAP (no idea what that is) and it works again.
    That Redemption is interesting. MS break their program so it won't work, then charge $280 Aus to make provision to fix it. Only MS would have the gall!
    Regards,
    Peter

  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Operations Error

    Thanks Jefferson. The IT guy made an adjustment to LDAP (no idea what that is) and it works again.
    Regards,
    Peter

  8. #8
    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: Operations Error

    Microsoft only removed the simpler, easier-to-program email functionality. Redemption is a third party wrapper around the more inscrutable Extended MAPI functions which Microsoft makes freely available to anyone who wants to spend several months figuring them out! If it wasn't for all the email viruses, of course, this never would have happened...

  9. #9
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Operations Error

    Thanks for that info Jefferson. The obvious question is why on earth does it take a third party to make good a MS induced problem?
    Regards,
    Peter

Posting Permissions

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