[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to programmatically using Access VBA to read a sub folder in public folders in Outlook?

Posted on 2008-11-12
Medium Priority
Last Modified: 2012-05-05
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?


How can this be done

Question by:indyng
  • 2
LVL 38

Accepted Solution

puppydogbuddy earned 2000 total points
ID: 22990807
The recursive function at the link below should do what you want.  Implementation is explained step by step and the source code is provided.
LVL 38

Expert Comment

ID: 22990836
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.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question