Appreciate the effort.

I think I'll post this in the OE groups.

--
Biff
Microsoft Excel MVP


"SixSigmaGuy" wrote in message
...
Sorry, I have no experience at all with Outlook Express. I was referring
to the Office version of Outlook. I'll do some investigation, though, and
reply if I find anything.
"T. Valko" wrote in message
...
Are you talking about Exchange/Outlook messages?

Yes. Specifically, Outlook Express.

then check the folders through VBA.

The messages aren't in folders, they're in *.dbx files, but, maybe that
doesn't matter?

I can give more details if you want and provide sample code

I would greatly appreciate that.

Here's the path to the file of interest:

C:\Documents and Settings\User\Local Settings\Application
Data\Identities\{long string}\Microsoft\Outlook Express\Inbox.dbx

Basically, I'm looking to create a UDF to be used like this in a
worksheet:

=Inbox()

And it returns the number of messages in the inbox file.

=Inbox() = 323

I gotta clean up my inbox!


--
Biff
Microsoft Excel MVP


"SixSigmaGuy" wrote in message
...
Are you talking about Exchange/Outlook messages? If so, you can simply
add a reference to Outlook and then check the folders through VBA.

I can give more details if you want and provide sample code, assuming
I'm understanding your problem correctly.


"T. Valko" wrote in message
...
Anyone have any ideas on this...

I want to come up with a UDF that returns the number of messages in an
email "folder".

Just some cursory looking around, the problem I see:

The messages aren't stored in a folder but rather in a *.dbx database
file (ie: inbox.dbx). It doesn't look like it's be possible to count
the messages within this *.dbx file. So, what other methods are there
to do this?

--
Biff
Microsoft Excel MVP