title: Using VBA in Outlook to gather statistics on received emails
body: <p>At work we use a shared Outlook mailbox to receive emails from our users, and at the moment we have a rota of who's turn it is to monitor the mailbox and reply etc. Our working hours have been 7am-5pm since we started the email address.</p>
  
  <p>For the next 2 months we're trailing a change in hours where we (or should I say, myself only) will be monitoring the mailbox up until 11pm.</p>
  
  <p>What I'd like to do is gather some statistics on the emails we receive to see if it is worth it from a business view to keep the later shift on after the trail.</p>
  
  <p>What I was thinking of doing is using some VBA to check the emails in the inbox, and then break the data down into some stats for management, eg:</p>
  
  <pre><code>Monday 06/05/12: 
  49 emails received, 34 were replies, 15 were new
  At 7am received: 0 emails
  At 8am received: 1 emails
  ------
  At 11pm received: 0 emails
  </code></pre>
  
  <p>etc</p>
  
  <p>To work out if an email is an original or reply I think it's easiest to see if the subject starts with RE:? (I know it's not foolproof but I think it'll work for basic stats)</p>
  
  <p>Has anyone done anything like this before? Is there an easy/right way of doing it?</p>
  
  <p>Anyone got any tips/code samples that would be useful?</p>