Recent content by Kev

  1. K

    Macro to search emails between two time slots on public folders with excel export

    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...
  2. K

    Macro to search emails between two time slots on public folders with excel export

    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...
  3. K

    Macro to search emails between two time slots on public folders with excel export

    Thanks a lot Diane, really helpful! Reposting your first message
  4. K

    Macro to search emails between two time slots on public folders with excel export

    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 =...
  5. K

    Macro to search emails between two time slots on public folders with excel export

    Thanks Diane, i had to leave the office for an external meeting, I ll run your kind suggestions when back and report! Best wishes
  6. K

    Macro to search emails between two time slots on public folders with excel export

    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...
  7. K

    Macro to search emails between two time slots on public folders with excel export

    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!
  8. K

    Macro to search emails between two time slots on public folders with excel export

    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...
Top