Oct 17

Querying Outlook

One of my developers is proposing to put the text of every error email that the web application generates into the database because they contain debug information. I’m not certain that anyone will use this information, so I wanted to estimate how space this was going to take up. I had a bunch of the error emails in my mailbox, and I discovered that if you highlight a bunch of messages, copy, and paste into Excel, you get the same grid. The sizes are strings (“34 KB”), but you can then use a formula to isolate the number (“=INT(LEFT(D2, LEN(D2)-3))”) and use the AVERAGE function on them.