Count mails in outlook in a specific shared folder in a fast way and can be read to array.

[TheOne23 7]

Hi Water / Experts,

May I ask your assistance if you have an idea about Count mails in outlook in a specific shared folder in a fast way and can be read to array.

Thank you.

Edited July 23, 2019 by TheOne23

[Nine 992]

Local $aItems = _OL_ItemFind($oOutlook, $oFolder, $olMail, "", "", "", "EntryID,SenderEmailAddress,SenderName,Subject,To", "", 1)
_ArrayDisplay ($aItems)

 

[TheOne23 7]

Hi Nine,

This is working but if you have like 1000 mails, it took more than 5 minutes before it returns an output.

[Nine 992]

58 minutes ago, TheOne23 said:

like 1000 mails

Maybe some cleanup would be welcome ?

[water 2,387]

Do you only need to count the items in the root folder or do you need the count for the root plus every subfolder?

[water 2,387]

You could have a look at _OL_FolderSize to retrieve the count and size of items in a folder / all subfolders.
If this is still too slow then a stripped down version should be much faster by dropping the size calculation.

[TheOne23 7]

Hi Water,

Thank you for your inputs. I will try this and will let you know on the output.

 

Thank you.

[water 2,387]

I have updated the OutlookEX UDF to Version 1.3.6.0.
_OL_Foldersize now supports a new parameter:

Quote

_OL_FolderSize: Parameter $bCountOnly has been added so you can quickly get the number of items in the folder/subfolders

 

[TheOne23 7]

Hi Water,

 

Where Can I download the latest UDF?

 

Thank you

[water 2,387]

Please check my signature

[TheOne23 7]

Hi Water,

 

I got this error extracting the zip file.

 

[water 2,387]

Seems Windows is unable to unpack the ZIP-file. Will upload a newly created archive.

[TheOne23 7]

Hi Water,

Sure. I'll wait for it. 😄

Thank you.

[water 2,387]

Done. Uploaded a new ZIP-file

[TheOne23 7]

Hi Water,

Zip file worked perfectly now.

Thank you so much for your usual support Water!

It is greatly appreciated.

 

[water 2,387]