create outlook folders incl subfolders from list in excel

i have an excel list of existing folders under my c/ (600 folders) automatically updated by vba when opening excel file, when a new folder is added to the c/ location, my excel list is automatically updated

I have now to create in Outlook a folder for each folder name.
if in Outlook, the folder already exist nothing to be done.
if not, each time a new name appears in the excel list, I would like a folder to be created in Outlook (Inbox/under folder "production").

I would like the Outlook folder created to have always the same structure with folder name from excel list (variable) with constant subfolders name structure as foolows:

1)Name of the file (variable) - folder name
A. 2023-2024
1. H&m
1.1. Shipyard
1.2. Others
2. P&I
3. War
4. crew
5. Claims
5.1 crew
5.2 H&M
5.3 P&I

would that be possible with VBA?
Note: i work mainly on mac but also in windows

Just to give you a start. This is the syntax for adding folders and subfolders.
It's up to you to create a proper loop etc.

Note: this method will not work on Macs.

Please Login or Register  to view this content.