Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Send E-mail (Access97, Win2K, OutlookXP)

    I have a database that sends e-mails that works fine under Win95/Access97/Outlook98.

    We've upgraded at work and are now on Access97/Win2K/ OutlookXP.

    When I "DoCmd.SendObject" Outlook prompts me saying that "A program is trying to automatically send mail on my behalf..." and waits for the user to click Yes.

    How do I avoid that annoying messagebox?

    Thanks!!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Send E-mail (Access97, Win2K, OutlookXP)

    Hi Morgan,
    You are being affected by the Outlook Security Patch/Feature - check out the thread associated with <post#=176774>post 176774</post#> in Outlook. You may also want to do a search on Security Settings in the Outlook forum - it seems to me I saw a way to disable that prompt in Outlook 2002, but I haven't been able to find it quickly. (Sorry about no longer being in CO, but you don't have quite the drought we do.)
    Wendell

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send E-mail (Access97, Win2K, OutlookXP)

    Morgan,

    You might check here for some code that appears to do what you want.

    As an alternative, you can check this page for more on the same issue. This post references the site mentioned above.

    Good Luck!

    Tom

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Send E-mail (Access97, Win2K, OutlookXP)

    You can't turn it off, and with the viruses floating around these days, you don't really want to. The way around it is to not use SendObject, which uses MAPI calls and generates the warning message. You get around it by not using MAPI. The Redemption library referenced in the other responses works quite well, but it has to be licensed and you have to write code to call its methods. We use it at work because our software products are designed to automatically send out emails based on the way the customer sets the program up, and the security patches make that impossible otherwise.
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send E-mail (Access97, Win2K, OutlookXP)

    In addition to the other responses, I have used the free ASPEmail component for sending mail from Access. It's available at:
    http://www.aspemail.com/
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  6. #6
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send E-mail (Access97, Win2K, OutlookXP)

    I appreciate the pointer to Redemption. It worked like a champ right out of the (electronic) box.

    Thank you!

    I miss CO greatly, especially duing the HUMID summer in MO, but I definately am glad I missed the fires & drought.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

Posting Permissions

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