Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Module to bypass outlook warning when sending object?

    Has anybody seen a code to bypass the warning you get when you email an object from within Access. I put some code in to try to send via smtp but due to the way our company accesses our mail server, I was not able to get it to send correctly this way. It seems like there would be a code to click on the yes button to allow emails to be sent without authorization. Any ideas on this?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What? That message that outlook gives that warns the user that some foreign application is trying to send mail automatically?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Yup, that's the one.

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    You don't actually 'Send' the email. Display the email instead and use sendkeys to 'push' the send button.

    A few things to keep in mind...
    If you're sending several emails, you can't use the PC until they've all been sent.
    If there is a limit on server space for your Outlook files, you may need to move emails from the sent folder to a local folder as you send them.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    How would I bypass outlook without using SMTP or third party programs?

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why can't you use SMTP?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    ...because of the way my company is reaching its email provider. They are using SMTP to bring it into our system and then imap for each user to access it. They protect from spam and potential viruses this way.

  9. #9
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    You can buy a little program (it has a 30 day trial period). I don't have the link handy but it has a name like Yes/No. A google search on the Outlook problem will find it.

    There are two versions. One is free and clicks the Yes. The one you buy (about $40US) simply bypasses it. If you wanted to go through multiple records in one go as on a form you would need the one you buy. I tried it and it works very well.

    I did not buy it because it was needed as I can use SMTP for people to use. One problem with SMTP I have is not having anything in the Send box and to use a Word doc as the background/body of the email requires my code to first save it as an HTM file. This is a bit of pest because of what is saved to the folder. But as i said for fancy emails with Word as the body and with Access data into the Bookmarks they are being used as one at a time emails.

  10. #10
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    PS,

    I just found the link. Scroll down for the details.

    A program is trying to send e-mail on your behalf. Stop this message with ClickYes.

  11. #11
    Join Date
    Mar 2009
    Location
    SLOVAKIA,Bratislava
    Posts
    70
    Free solution, it works OK....
    Outlook-Send-E-mail-Without-Security-Warning
    15 years db-programmer(dBase,FoxPro,MS Access 2002/2003),Symbian C++

  12. #12
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Good links Mike375 and pacala_ba!

    I've been looking for ways around Outlook's message box and anxious to try this out.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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