indyng
asked on
How to programmatically using Access VBA to read a sub folder in public folders in Outlook?
Hi Experts,
How to programmatically using Access VBA to read a sub folder in public folders in Outlook?
There are 4 levels of sub folders within the "Public Folders" (see attached pic file)
I want a Access VBA to save the attached Excel files from each email in each sub folder contained in the "Terminal Logs" folder to a folder on my local computer.
There are multiple emails but I want the email with yesterday's date.
How can this be done using VBA in Access?
Thanks
How can this be done
Public-Folders.gif
How to programmatically using Access VBA to read a sub folder in public folders in Outlook?
There are 4 levels of sub folders within the "Public Folders" (see attached pic file)
I want a Access VBA to save the attached Excel files from each email in each sub folder contained in the "Terminal Logs" folder to a folder on my local computer.
There are multiple emails but I want the email with yesterday's date.
How can this be done using VBA in Access?
Thanks
How can this be done
Public-Folders.gif
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, I misread the post. I missed the word "save" and thought you wanted to list the files in the public folders. Nonetheless, I believe the above code can be adapted to perform "saves" to the public folders.