Results 1 to 4 of 4
  1. #1
    hazeleyre23 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    34

    Your database or project contains a missing or broken reference to the file 'MSOUT.OLB' Version 9.4

    Hi,



    I am getting the following error message and I believe it has something to do with the way I am sending an automatic email when a file is updated. However I am new to Access so unsure what I need to change in my code. I am using Access 2010 and Outlook 2010.

    Code:
                Dim objOLApp As Object
                Dim outItem As Object
                Dim DestFolder As Object
                Dim outNameSpace As Object
                        
                'On Error GoTo Err_SetupOutlookEmail
                        
                Set objOLApp = CreateObject("Outlook.Application")
                Set outNameSpace = objOLApp.GetNamespace("MAPI")
                Set outFolder = outNameSpace.GetDefaultFolder(6)
                Set outItem = objOLApp.CreateItem(0)
                                   
                'DEFINE THE GROUPS
                Agent_Name = Me.txtNewAgentName
                Site = Me.cboNewSite
                Dept = Me.cboNewDept
                Team = Me.cboNewTeam
                 
             With outItem
                    'EMAIL ADDRESS
                    .To = ""
                    .CC = ""
                    .BCC = ""
    
    
                    .Subject = "New file added - " & Me.txtNewAgentName
                    
                    'Set Body Format to HTML
                    .BodyFormat = 2
                    
                    'Format the Message
                    .HTMLBody = _
                        "<html>" & _
                            "<font size = '2' face = 'Calibri'>" & _
                            "<b>" & "Agent Name: " & "</b>" & Me.txtNewAgentName & "<br>" & "<br>" & _
                            "<b>" & "Site: " & "</b>" & Me.cboNewSite & "<br>" & "<br>" & _
                            "<b>" & "Dept: " & "</b>" & Me.cboNewDept & "<br>" & "<br>" & _
                            "<b>" & "Team: " & "</b>" & Me.cboNewTeam & "<br>" & "<br>" & _
                        "</html>"
                    .Send
                End With

    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you checked to see if anything is amiss in your references?

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the VBE (ctl-G) , menu, TOOLS, REFERENCES.
    see if any items checked are listed as MISSING.

    If it is Microsoft OUTLOOK , then uncheck the missing one, and scroll down the list and checkmark Microsoft Outlook object library v.???
    The current one may be looking for an out of date version.

  4. #4
    hazeleyre23 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    34
    Thank you for your replies.

    There was no references listed as MISSING, however I have got another colleague to have a look as it may have been un-ticked when I have moved it.

    Thank you

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

Similar Threads

  1. Replies: 4
    Last Post: 04-06-2016, 07:16 AM
  2. Missing or Broken Reference
    By MaineLady in forum Access
    Replies: 4
    Last Post: 12-19-2014, 08:06 PM
  3. Replies: 1
    Last Post: 06-07-2013, 09:32 AM
  4. Broken link missing reference
    By Cran29 in forum Access
    Replies: 1
    Last Post: 04-25-2013, 02:03 PM
  5. Replies: 1
    Last Post: 06-23-2011, 07:19 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