See this post he
http://excelforum.com/showthread.php?s=&threadid=242708

I think it would be better suited to this forum rather than exce
-miscellaneous.

Any help would be appreciated.

AussieM8

PS - for some reason, Dick's subroutine won't work for me at al
(http://www.dicks-clicks.com/excel/olRetrieving.htm

--
Message posted from http://www.ExcelForum.com

AussieM8 wrote:

See this post he
http://excelforum.com/showthread.php?s=&threadid=242708

I think it would be better suited to this forum rather than excel
-miscellaneous.

Any help would be appreciated.

AussieM8

PS - for some reason, Dick's subroutine won't work for me at all
(http://www.dicks-clicks.com/excel/olRetrieving.htm)


---
Message posted from http://www.ExcelForum.com/

Please give the news: reference. I have limited web access here but
NNTP is no problem.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?

AussieM8

Open Outlook and choose View - Folder List. This will give you the tree
view of your outlook folders. The top level of folders can be called from
the NameSpace object. The key to getting to the right folder is knowing the
path. An example of a path in my outlook is

olNS.Folders("Personal Folders").Folders("Inbox").Folders("Blog")

However, if you have a different set up than me (like if you're using
Exchange) then your folder path may be considerably different. Looking at
the folder list should make the path seem clear.

If that doesn't get you where you need to be, you can email me a screen shot
of your folder list and an example of the code that doesn't work.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"AussieM8 " wrote in message
...
See this post he
http://excelforum.com/showthread.php?s=&threadid=242708

I think it would be better suited to this forum rather than excel
-miscellaneous.

Any help would be appreciated.

AussieM8

PS - for some reason, Dick's subroutine won't work for me at all
(http://www.dicks-clicks.com/excel/olRetrieving.htm)


---
Message posted from http://www.ExcelForum.com/

Thanks for the reply Dick.

I tried using that folder path, but it must not be the correct one.
The code I am using is the same as in the thread quoted:

http://excelforum.com/showthread.ph...threadid=242708

I'll shoot you an email with the screen shot and see if that shed's an
light on it. I'm using Excel/Outlook 2000 running on W2K at my work.
It is a large network, so perhaps the folder path is where my proble
lies.

Cheers,
AussieM

--
Message posted from http://www.ExcelForum.com

AussieM8

I saw the screen shot and it looks to me like you're doing it right. I sent
you a mail to try this

Debug.Print oNameSpace.GetDefaultFolder(olFolderInbox).Parent. Name

I'll be interested to see what that returns.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

Thanks for the reply Dick.

I tried using that folder path, but it must not be the correct one.
The code I am using is the same as in the thread quoted:

http://excelforum.com/showthread.ph...threadid=242708

I'll shoot you an email with the screen shot and see if that shed's any
light on it. I'm using Excel/Outlook 2000 running on W2K at my work.
It is a large network, so perhaps the folder path is where my problem
lies.

Cheers,
AussieM8


---
Message posted from http://www.ExcelForum.com/