Results 1 to 8 of 8
  1. #1
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23

    bypass the Outlook security message

    There is a thred on the following link to bypass the Outlook security message .

    http://www.tek-tips.com/faqs.cfm?fid=5230

    It is for Sending Mail.

    I've tried it for drag and drop an email from Outlook to a memo field from the following link but it does not work for me.

    http://www.tek-tips.com/viewthread.cfm?qid=1346884

    The routine for drag and drop works for me but I would like to get rid of the security message "a program is trying to access e-mail addresses etc......"

    any idea?


  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Answered in another forum. Did you define the Turn_Auto_Yes_On sub and Call it?

  3. #3
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23
    Private Sub Turn_Off_Auto_Yes()
    Dim wnd As Long
    Dim uClickYes As Long
    Dim Res As Long
    uClickYes = RegisterWindowMessage("CLICKYES_SUSPEND_RESUME")
    wnd = FindWindow("EXCLICKYES_WND", 0&)
    Res = SendMessage(wnd, uClickYes, 0, 0)
    End Sub

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    And then it is used here:
    Sub Send_Mails()
    Dim appOutLook As Outlook.Application
    Dim MailOutLook As Outlook.MailItem

    'Enables automatic "YES" clicks for Outlook
    Turn_Auto_YES_On
    ...except this should be a Call:
    Call Turn_Auto_YES_On

  5. #5
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23
    "Call" didn't help
    The "Declare Windows' API functions" uses Lib User32
    In Tools>References there isn't entry for User32 and when I try to add User32.dll
    I get "can't add a reference to theb specified file"
    I am using access 2003.
    Thanks

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You do not need to add that to your references. What OS are you using?

  7. #7
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23
    XP SP3
    I'v tried it on WINDOWS 7 and ACCESS 2007 - Same result

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you single stepped the code to see if it is executine? I've used ClickYes successfully before with no issues.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Outlook error message using SendObject method
    By Juan23 in forum Programming
    Replies: 3
    Last Post: 07-10-2013, 12:03 PM
  2. Import Outlook email message
    By crowegreg in forum Import/Export Data
    Replies: 5
    Last Post: 09-27-2011, 11:10 PM
  3. bypass file picker?
    By techneophyte in forum Programming
    Replies: 6
    Last Post: 08-17-2010, 11:12 AM
  4. Bypass startup to allow design
    By cjbuechler in forum Access
    Replies: 1
    Last Post: 06-25-2010, 03:38 AM
  5. Replies: 1
    Last Post: 03-09-2006, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums