• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

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
0
indyng
Asked:
indyng
  • 2
1 Solution
 
puppydogbuddyCommented:
The recursive function at the link below should do what you want.  Implementation is explained step by step and the source code is provided.
                     http://allenbrowne.com/ser-59.html
0
 
puppydogbuddyCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now