Check if a mailbox folder exists

[fcomino]

Hey Guys

I have the following code which counts items in a mailbox:

Please Login or Register  to view this content.

I want to be able to run a check to see if the mailbox exists before I do an email count.

So I need an IF statement to check if mailbox exists in destination, if yes then run email count and put in Cells(x,y) else if mailbox doesnt exist then put "N\A" in Cells(x,y).

[snb]

Why so complicated ?

Please Login or Register  to view this content.

Thsi code runs in Outllook. (not in Excel)

[fcomino]

I need this to run in Excel...

Its a scheduled report that I run everyday on about 10 mailboxes. Its counts all the items in each mailbox.

If someone else runs it, i want it to show which mailboxes they dont have.

[snb]

From Excel

Please Login or Register  to view this content.

[fcomino]

Ummm This is not what I want. Thanks for your help though.

For Each mailbox I need a count of all the items in the Inbox. These are then displayed in a particular cell that I assign it to. I have already done this. See the Code above.

The only thing I am unable to do is:

If the mailboxes is not available, in that desginated Cell in Excel I want it to display N\A, instead i am getting error messages.
I know how to clear them, but instead I want it to display N\a in the cell.

[romperstomper]

Try this:

Please Login or Register  to view this content.

[fcomino]

Works Like a charm!

Thanks

[snb]

Somewhat compacter

Please Login or Register  to view this content.

[romperstomper]

I'll take legible over compact any day...
IIf is also slower than If..Then.