View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SixSigmaGuy[_4_] SixSigmaGuy[_4_] is offline
external usenet poster
 
Posts: 20
Default Count of email messages

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