Excel VBA error trying to create new Outlook instance [2 versions of Outlook installed]

[mcsythera]

Microsoft Visual Basic
Run-time error '-2146959355 (80080005)':
Server execution failed

The above error occurs in Microsoft Office 2019 Excel while running the following code:

Please Login or Register  to view this content.

After troubleshooting with the user attempting to run the code, we determined that there was a new version of Outlook that she was using (which was open), that is different from the original version. Both versions show up on the system, but the new version has "(new)" appended after it. While this new version is open, the above code does not find an Outlook instance and therefore tries to open the old version, which from the error I can only assume will not open if the newer version is already open.

Is there a better way to check for more up-to-date versions of the same application in order to determine if the application is already open before trying to open the application, or a better way to open the application that won't interfere with other open instances of the application? The current workaround was to ensure that the new version of Outlook was not automatically turned on (she had a toggle button for the new version) when she opened Outlook. The VBA works fine while the original version is open, or Outlook is closed but the toggle for the new version isn't on.

The purpose of the code is to automatically create an email that is sent with information from the userform that this code is a part of, namely as a notification system.

[Gtrtim112]

I'm experiencing the same issue. My VBA code opens Outlook and generates a new email with no issue. It will not work if I switch over to the new Outlook version.
I've subscribed to this thread in hopes you get a reply.

[ByteMarks]

Please Login or Register  to view this content.

My understanding is that "New Outlook" doesn't support VBA.


https://feedbackportal.microsoft.com...c-000d3ae46fcb