Results 1 to 4 of 4
  1. #1
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150

    Run-time error when attempting to open Outlook

    Every since mt database was created several years ago I have used the following code to connect to outlook and it has worked fine. Nowadays however it fails with the run-time error show in the attached sceenshot.

    Code:
    Dim oApp As Outlook.Application
    Set oApp = CreateObject("Outlook.Application")
    I have also tried
    Code:
    Dim oApp As Object
    Set oApp = CreateObject("Outlook.Application")



    Click image for larger version. 

Name:	Outlook Error.PNG 
Views:	12 
Size:	13.4 KB 
ID:	49010

    I'm completely stumped so any help would be appreciated.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,998
    No idea, sorry, but it has occurred many times for many users.

    https://www.google.com/search?q=crea...hrome&ie=UTF-8
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150
    Quote Originally Posted by Welshgasman View Post
    No idea, sorry, but it has occurred many times for many users.

    https://www.google.com/search?q=crea...hrome&ie=UTF-8
    Thanks for the comment. I did Google extensively for a solution. I'll go through some of these instances for the problem. It's worked perfectly for years. Very strange.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,998
    Have you had any updates at all?
    I had a problem with my outlook, where I had set it for opening in admin mode on my new laptop, which was an old works laptop.
    Access could not open Outlook saying it required elevation. Took me a while to identify that I needed to run Access in admin mode to be be able to open Outlook at that level.

    Don't ask me why I had Outlook in admin mode. It would have been ages ago when I was using it in work, and for some reason or another.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 2
    Last Post: 02-08-2022, 10:19 AM
  2. Error when attempting to open report
    By jbeets in forum Modules
    Replies: 5
    Last Post: 07-24-2020, 07:22 AM
  3. Replies: 1
    Last Post: 09-22-2016, 05:05 AM
  4. Replies: 11
    Last Post: 05-20-2014, 11:32 AM
  5. Sending Outlook E-mail - Run-time error '429'
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 03-01-2011, 09:30 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