Results 1 to 4 of 4
  1. #1
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283

    A program is trying to access e-mail address information stored in Outlook

    Hi there,

    I upgraded to Office 2016 from 2013 and now I get this message when my access databases try to send emails using vba. This did not happen in the older version.

    I have run outlook as an administrator and set the Programmatic Access to Never warn me but the blasted Allow Deny For how many minutes still pops up. The Antivirus section at the bottom says unavailable This version of WIndows does not supprt anti virus. All of this is installed on a windows 2012 R2 Server

    I noticed I did have to add the Microsoft Office 16 Object reference to get the database to send the email but now it is stuck at the Allow Deny stage.

    Ca anyone help me get this to just let the emails go though.



    Thanks in advance

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Are you using SendObject?

    As long as I keep MS virus protection up to date, I don't get the warning.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    Quote Originally Posted by June7 View Post
    Are you using SendObject?

    As long as I keep MS virus protection up to date, I don't get the warning.
    this is the script I use

    Code:
                            ' Add the CC recipient(s) to the message.
                   'Set objOutlookRecip = .Recipients.Add("name.name@email.com")
                   'objOutlookRecip.Type = olCC
    
    
                 ' Add the BCC recipient(s) to the message.
                  Set objOutlookRecip = .Recipients.Add("name.name@email.com")
                  objOutlookRecip.Type = olCC
    
    
                 ' Set the Subject, Body, and Importance of the message.
                 .Subject = "Team Reports"
                 .Body = "This is an unmonitored mailbox. Please send concerns to Name at name@name.com." & vbCrLf & vbCrLf
                 .Importance = olImportanceNormal  'Normal importance
    
    
                 ' Add attachments to the message.
                 If Not IsMissing("C:\file.xlsx") Then
                     Set objOutlookAttach = .Attachments.Add("C:\file.xlsx")
                 End If
    
    
                 If Not IsMissing("C:\file2.xlsx") Then
                     Set objOutlookAttach = .Attachments.Add("C:\file2.xlsx")
                 End If
                 
                  If Not IsMissing("C:\file3.xlsx") Then
                     Set objOutlookAttach = .Attachments.Add("C:\file3.xlsx")
                 End If
                 ' Resolve each Recipient's name.
                For Each objOutlookRecip In .Recipients
                   objOutlookRecip.Resolve
                 Next
     ' Should we display the message before sending?
                 If DisplayMsg Then
                     .Display
                 Else
                     .Save
                  .Send
                End If
              End With
              'Set objOutlook = Nothing
    End Sub

  4. #4
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    it seems to have settled down most of the errors by adding Office 16 Object and Outlook Object 16. The only ones still giving me the error message are the databases where the email is sent through a macro with Email DatabaseObject

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

Similar Threads

  1. Replies: 1
    Last Post: 02-04-2020, 04:53 PM
  2. Replies: 2
    Last Post: 12-01-2015, 10:14 PM
  3. Replies: 1
    Last Post: 03-15-2012, 05:41 PM
  4. How to e-mail from access to outlook
    By hogue@montana.com in forum Programming
    Replies: 5
    Last Post: 02-17-2012, 12:33 PM
  5. Replies: 16
    Last Post: 03-15-2010, 12:02 AM

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