Diane, thanks so much this was indeed the solution!! Absolutely brilliant! The Macro works perfectly well on both local folders and PF folders, this makes retrieving emails in a huge inbox a breeze!
i am pasting here the full macro for other users - Many thanks to the original creator and to...
Diane,
I was trying out your suggestion - if i understand well the code on the Sub should be like this?
Or should i remove completely the
If olkFol.DefaultItemType = olMailItem Then
Sorry for my total imcompetence!
Private Sub SearchSub(olkFol As Outlook.MAPIFolder)
Dim olkHit As...
Diane,
I have tried various suggestions - stepping into the code and comparing what the macro is doing when its working properly on a "local" folder and when its not working on a "PF" folder.
As far as i can see, when executing on a PF, the Macro stumbles on If olkFol.DefaultItemType =...
Diane,
Thanks a lot - adding the msgbox olkFol.name line and running the macro while selecting a PF folder, the macro does find the PF folder and subfolder but the excel files is blank appart from the header columns even though there should be some emails which correspond to the search...
Thanks Diane for your reply!
The Macro returns a blank file when I run it form a public folder - it works on all "local" folders (Inbox, sent items etc) but doesnt work on any folder on the server - not sure why!
Hey guys,
New to this forum, fantastic ressource for non-advanced Outlook user like myself! Learning a lot just reading through posts and creating some basic macros in VBA!
I have a specific problem in Outlook 2013 that I cannot solve via the Advanced Query Builder and that I believe a macro...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.