So your question is not how to write data into Excel, but how to read
Outlook's folder hierarchy. Please see Sue's answer. I'd maybe have answered
the Excel part - and wasted my time :-)

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --

Am Wed, 29 Nov 2006 01:23:03 -0800 schrieb Vadhimoo:

Dear Michael,
Thanks.I know extract mails from INBOX. My question is in our INBOX having
more than 2000 sub folders. I want to extract all my sub folders name to
excel or access.
Like...
Inbox
USA2000
Newzeland2002
...........

"Michael Bauer [MVP - Outlook]" wrote:


You already have code for extracting mails to Excel. What is your
question
now?

BTW: I'd say, you urgently have to switch your system away from folders
to
categories.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --

Am Tue, 28 Nov 2006 18:47:00 -0800 schrieb Vadhimoo:

Hi
We are having more than 2000 folders in our INBOX. We would like to
extract
all the folders name to excel. How can we extract all the folders
name..?

Thanks in advance for your reply.