Importing email from outlook

[AussieM8]

See this post here:
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

 

[Amedee Van Gasse]

See this post here:
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)

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

 

[Dick Kusleika]

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.

 

[AussieM8]

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

 

[Dick Kusleika]

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.