Thanks, every day I am learning something new
thanks Dick and Chip
"Chip Pearson" wrote in message
...
You need to set a reference to the Outlook type library. In the
VBA editor, go to the Tools menu and choose References. In that
dialog, find "Microsoft Outlook 9 Object Library" and put a check
next to it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Barmaley" wrote in message
...
yes it is in MS Exchange environment.

I tried yor code, but I am getting error:
"Compile error: user-defined type is not defined"
for first 3 statements
Dim olApp As Outlook.Application
Dim olNs As NameSpace
Dim Fldr As MAPIFolder

Am I missing something. I have MS Excel 2000

Thanks

"Dick Kusleika" wrote in
message
...
Barmaley

Here's the basics

http://www.dicks-clicks.com/excel/olRetrieving.htm

I don't have Exchange (which is where I assume public folders
come from)
so
you'll have to modify it to find the public folders.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Barmaley" wrote in message
...
Is it possible to retreive number of e-mails for each day
from public
folder
in Outlook to Excel?

Info I need is simple, just date and number of e-mails, for
ex:

Date E-mails
7/15/2003 25
7/16/2003 13
etc...