topic Re: Issue with fetching email from a specific folder in MS Outlook in Product Forum

Issue with fetching email from a specific folder in MS Outlook

Anonymous — Wed, 03 May 2023 08:42:41 GMT

Hello,
I am working on a project where some specific emails are stored in a folder called "testing" (screenshot 1). I need to read only these emails. For this reason I used MS outlook email VBO "get received email (basic)" with subfolder name "testing" (screenshot 2). Unfortunately, it shows the result 0 ( item count: 0, item: empty). How can I solve this problem?

Note: Blue Prism version 7.1.2, Outlook version: MS 365

Screenshot 1:

Screenshot 2:

Re: Issue with fetching email from a specific folder in MS Outlook

Babjee24 — Wed, 03 May 2023 12:38:24 GMT

Hi @Ekram Shihab ,

Reading from sub folder mean it should a child folder for Inbox as shown in below screenshot. Here BP Community is a subfolder of Inbox from which we can read emails from, whereas Test is not a subfolder

We can read an email from the other folder outside of Inbox by knowing the MAPI Folder ID that is mapped to it by outlook. By default the Folder ID for Inbox is 6 (as shown in screenshot) similarly if you can get the folder ID that is mapped to the folder outside the Inbox in your case for testing.

Hope this helps for you

Re: Issue with fetching email from a specific folder in MS Outlook

Anonymous — Wed, 03 May 2023 13:10:48 GMT

Hi @Babjee Vangipurapu,
Yes, you are right. I tried it creating a sub folder in INBOX named "testing". It worked for me. But in my case, testing is another folder.

And regarding folder Id, I have understood your concept. It's a nice concept. But how can I find out the folder ID of the folder "testing"? Do you have any clue? I have found the following link in the internet.

OlDefaultFolders enumeration (Outlook) | Microsoft Learn

Re: Issue with fetching email from a specific folder in MS Outlook

Babjee24 — Wed, 03 May 2023 15:38:11 GMT

Hi @Ekram Shihab ,

I'm also trying to find a script that can find the Folder ID given the folder name as an input. Looping fellow community members and Blueprism advisory for further tips. @Tejaskumar_Darji @devneetmohanty07 @Harish M @ewilson @_Amlansahoo if you've any inputs on how to find Folder ID that has been created in outlook would be of great help.

Re: Issue with fetching email from a specific folder in MS Outlook

ewilson — Wed, 03 May 2023 16:05:42 GMT

@Ekram Shihab

Have you downloaded the latest release of the Outlook VBO from the Digital Exchange? If not, start with that. Once you have it, you'll want to look at the action Get Items in Folder. Check the help or user guide for details about how to reference folders using the \\ notation.

Cheers,
Eric

Re: Issue with fetching email from a specific folder in MS Outlook

Anonymous — Thu, 04 May 2023 08:14:08 GMT

Thanks @ewilson for informing the new update of the MS Outlook VBO. It worked.
@Babjee Vangipurapu you can also have a look.

Re: Issue with fetching email from a specific folder in MS Outlook

Adam.Rojdemark — Thu, 28 Dec 2023 09:47:40 GMT

@ewilson

Get Items in Folder does not seem to work for a sub folder within a "Shared Mailbox" (I've tested Get Received Items as well, it gives same result). Is there a solution to this problem?

Fetching from Inbox which works:

However, trying to fetch the item in the sub folder:

Re: Issue with fetching email from a specific folder in MS Outlook

ewilson — Thu, 28 Dec 2023 16:36:15 GMT

Hi Adam,

First, are you using the latest release of the VBO available from the DX? Second, can you try changing your folder name to something like test and try it again? Occasionally, special characters or even white space at the end of the folder name can cause the search to fail.

Cheers,

Eric

Re: Issue with fetching email from a specific folder in MS Outlook

Adam.Rojdemark — Fri, 29 Dec 2023 09:26:03 GMT

Yes, I have the latest version. For some reason it worked today after I changed the name of the sub folder. It even worked after I changed back to "sub-folder". Very strange...

Anyways, thanks for a quick response!

Re: Issue with fetching email from a specific folder in MS Outlook

ewilson — Tue, 02 Jan 2024 13:58:29 GMT

Adam,

One thing that might have played into this is that Shared Mailboxes aren't always sync'd to the local PST file in real time. There's a setting in Outlook that controls how they are managed. The Outlook VBO uses the local Outlook API to interrogate data in the PST, so if the folder hasn't sync'd from Exchange to the PST that could cause the search to fail. 🤷‍♂️

Cheers,

Eric