Creating mulitple subfolders

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

I have been trying to find a way to create many subfolders at one time. My
tree is like this:

2009
09-001 to 09-100
Click to expand...

Currently the "fastest" way to do this is by using the move folder option so
that I don't have re click create folder every time; but I still have type
each folder name. They are sequential.

Is there any code I could use to do this faster and easily? I am going to
create about 500 folders for each year.

I have an add on I use for excel which will create lots of folders in
windows for me with whatever names I choose. To do this I create a list in
excel (vertically and in individual cells)
09-001
09-002
etc
Then the add in will create all of those folders (named as the cell) for me
in the location I choose.

I thought maybe I could use that but I don't think there is anywhere to
identify what the folder tree is?

I hope this is not too confusing; it is hard for me to explain it. Thank you
 
Actually, creating a folder is very simple. This creates an e-mail folder in
your Inbox:

Dim Inbox as Outlook.Mapifolder
Dim Subfolder as Outlook.Mapifolder

Set Inbox=Applcation.Session.Getdefaultfolder(olFolderInbox)
Set Subfolder=Inbox.Folders.Add("my first new folder")


--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Tue, 24 Mar 2009 15:36:02 -0700 schrieb Samantha:
I have been trying to find a way to create many subfolders at one time. My
tree is like this:

2009

Currently the "fastest" way to do this is by using the move folder option so
that I don't have re click create folder every time; but I still have type
each folder name. They are sequential.

Is there any code I could use to do this faster and easily? I am going to
create about 500 folders for each year.

I have an add on I use for excel which will create lots of folders in
windows for me with whatever names I choose. To do this I create a list in
excel (vertically and in individual cells)
09-001
09-002
etc
Then the add in will create all of those folders (named as the cell) for me
in the location I choose.

I thought maybe I could use that but I don't think there is anywhere to
identify what the folder tree is?

I hope this is not too confusing; it is hard for me to explain it. Thank
Click to expand...
you
 
Back
Top