Hello There!

I have an Excel workbook that sends automatic emails via Outlook 2000.

I am finding that when the users Outlook Mailbox is full that the workbook crashes as the email does not get sent correctly.

To try and combat this I have added an error handler to catch the problem when an email is not sent due to the Mailbox being full and it can continue without sending the mail.

However, as the email is required, I would like to test for the problem before the email is sent so that the user can delete some mail before trying the operation.

Currently I cannot find a method for testing if an outlook Mailbox is full. Does anybody know a method for testing the status of a mailbox? Or a way to ensure that the mail is always sent.

Cheers
Christian