There is perhaps a better way to do what you want than using Excel.

I assume that your size limitation in Outlook is like mine and it is
based on messages in your PUBLIC FOLDERS. You can solve this by moving
mail from the Public Folders to your Personal Folders.

In Outlook, under Personal Folder, create another folder for Inbox
(call it "A -My Inbox")(The "A" keeps the folder at the top of the list
of Personal Folders where it is easier to find). Then create a Rule
using the Rules Wizard (Tools Rules Wizard) to move all messages 1kb
<10000kb in size to this new inbox and delete them from the Public
Folder Inbox. Then simply do your work from the "A-My Inbox".

This rule will only run when you have Outlook open so when you first
open Outlook, you will see new mail in the original Inbox for a few
seconds but then they should automatically be copied and then deleted.
You should also do the same thing with your sent items folder (if you
automatically save outgoing mail in this folder). The only other
glitch in this process is that if you are on vacation for an extended
period and don't open Outlook during that time, the rule never gets
activated and mail continues to collect in the public folder Inbox -
and your Outlook will begin rejecting incoming mail based on your inbox
being full.

Otherwise, it works great - I haven't had a problem for over three
years.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=499238