title: How do you extract phone numbers from email bodies in Outlook?
body: <p>I have a pretty large account full of ~20k emails in Outlook and I need to extract phone numbers from those emails.</p>
  
  <p>An example of an email would be:</p>
  
  <pre><code>From: Amy Schwartz &lt;amy@blahdyblah.com&gt;
  
  Dear Anatoliy, 
  I want you to do blahdy blahdy blah.
  
  Amy Schwartz
  (347) 555-1212 &lt;---- I want this
  Blahdy Blah Company
  </code></pre>
  
  <p>The idea is to go through every email and match the last Phone number via regex and export a list in the following format:</p>
  
  <ul>
  <li>Name: Name from the "From" field</li>
  <li>Email: Email from the "From" field</li>
  <li>Phone: The last phone number matched in the email text</li>
  </ul>
  
  <p>Do you have any ideas on how to go about doing this? </p>
  
  <p>UPDATE: Didn't find any prebuilt solutions, but I'm hacking together my own <a href="http://www.codetwo.com/freeware/outlook-export/" rel="nofollow">using this</a>. codeTwo Outlook Express. You can export any email field (body, HTML body, from, from name) to CSV. It's a little slow (3 seconds a message on my i7 iMac running a Win7 VM). But it works :) And from there I will probably just put in a database and do some regex magic. Will post process once I'm done. </p>