Retrieving Outlook folder using GetNamespace causing Runtime error

[rrs711]

I have a macro that moves the currently selected email to a folder based on a keyword in the subject line matching a folder name. The macro extracts the keyword and then recursively descends the Outlook folder tree beginning with a "startFolder" which I manually define. The macro has been running just fine for months. Then the other day it stopped working.

Please Login or Register  to view this content.

....

Now the Set statement results in a runtime error:
Runtime error ' -2147221233 (8004010f)':
The attempted operation failed. An object could not be found.

Again, this was working just fine, no changes. I exported the module and reimported just in case it was corrupted (that's solved other problems), but that did not work.

[vba_php]

WHAT module? the entire PST? or the coding module? if you changed nothing, literally, and no ancillary stuff changed, like ANYTHING else that affects your outlook operations, syncing efforts, or anything else possibly related, then corruption makes perfect sense. office programs are notorious for causing it. but there *are* things wrong with ur code, that are completely redundant. why this?

Please Login or Register  to view this content.

why not just this?

Please Login or Register  to view this content.

you've post this in the outlook forum.

if it's not corrupted, the error desc makes perfect sense:

The attempted operation failed. An object could not be found.

something in here can't be found:

Please Login or Register  to view this content.

what are all the ''x''s for? are you really searching for a subfolder 4 nestings deep?

I've had numerous corrupted PST files over the years. I've used tools to fix them, if I remember right. when I found out how bad outlook really was, I started exporting them regularly because they were so unpredictable. check here:

https://www.systoolsgroup.com/update...outlook-error/

I couldn't find your error in MS's list either:

https://docs.microsoft.com/en-us/off...error-messages

[rrs711]

Thanks for the prompt response.
As you might have inferred, I'm not that skilled as a programmer--I more or less cobble together stuff that works based on what I can learn on the fly. Hence the redundancy.

The code runs in Module1.

The "xxx" are simply there to suppress the details of my email and business. Yes, I'm starting 4 levels down at "Projects" because that's where all of the emails are going to be stored. Within Projects there are 4 or 5 levels further down, with hundreds of folders. That's simply the nature of my business operations.

Everything else in Outlook works. The other macros in this module work fine as well. Just this one.

[rrs711]

I've cleaned up the code per your comments. Here is main sub

Please Login or Register  to view this content.

One thing that I just discovered is this: When Set Namespace executes, the properties returned include:

: AutoDiscoverConnectionMode : The attempted operation failed. An object could not be found. : OlAutoDiscoverConnectionMode

As best as I understand it, this suggests a problem connecting with Microsoft Exchange Server?

Also, the properties show

: ExchangeStoreType : olNotExchange : OlExchangeStoreType

and

- : MAPIOBJECT : : Unsupported object type

[vba_php]

the only way I can help you further is for you to upload the PST in a zip folder or something. you have only pointed out one issue. and I gave everything I could think of on that issue. sorry. one thing I would say is that, if you have millions of folders nested like you say, in a small program in outlook, you really need to find another warehousing space for your content. outlook is not designed as a large enterprise program, although MS says the word ""enterprise"" in all their offerings. that means nothing, to me anyway. outlook CAN do it, but given the unreliable nature of office products, my suggestion is a change.

[rrs711]

What precisely would you need in the PST? All folders?
Again, thanks for your help here, much appreciated.

[vba_php]

pretty much. give me the exact replica of what you're working with now. you don't have to include any of the email messages in them, as those are all exported out with the archive when you bundle everything together into a PST export. do you know how to write a short routine to strip all of that out of there? you don't really need to I suppose. really what I need more than anything is the architecture you are working with. by default, when you link OL to a server-based client of anything, like gmail, OL automatically creates 2 nestings of folders underneath 2 parent folders. one if apparently inherent to OL, and on is labeled as the client you are pulling email from. at least that's what I have always seen happen. as an example, I am showing you what I see in my OL. I have gmail linked to it. as you can see on the right side, it shows exactly what I have described.

[romperstomper]

Now the Set statement results in a runtime error:

There are two Set statements in the code you posted - which one causes the error?

[vba_php]

I couldn't possibly think it was this one:

Please Login or Register  to view this content.

Set startFolder = Namespace.Folders("G Suite - xxxxx.com").Folders("Mail Folders").Folders("XXXXX").Folders("Projects")
[/CODE]
personally I've never seen. we will see though.

[rrs711]

Rorya: set startFolder is what causes the error.

If I knew how to strip emails from the PST files, I would probably be smart enough to figure out the problem I'm having. Given the nature of my work (I'm an attorney) I can't send you a file that has client confidential information in it, such as emails.

[romperstomper]

Ok, that would suggest that one of the folders can’t be found. I’d try each in turn, building up the hierarchy until it fails - i.e.:

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

[vba_php]

that would pretty much be the only way to try and find out the error.

[rrs711]

Rorya--As Mace Windu would say: That the was clue to the mystery of the Set! (sorry, but we've been binge watching Star Wars)

I did what you suggested (I did them all at once) and it failed on the top level "Gsuite - xxxxx.com".

I'm so lame. Google changed the name from "G Suite" to "Google Workspace" and I did not notice that. G Suite was still coming up in the underlying properties, but had changed in the actual folder name.

Once I corrected that, everything worked.
Thanks all.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[rrs711]

Thread annotated and reputations updated. Thanks for the guidance.

[romperstomper]

Glad to help, and thanks for the rep.