title: Can Excel send an email to different users based cell value?
body: <p>I wanted to know if it's possible/viable/logical before attempting to do it.</p>
  
  <p>I have a shared document on a network drive that about 20-30 people work on/update.</p>
  
  <p>There are multiple fields, multiple sheets.</p>
  
  <p>Across a number of sheets there is a USER colum and a STATUS column.</p>
  
  <pre><code>ROW   ITEM               USER              STATUS
  ----------------------------------------------------
  1     Web Job 1          John             In Progress
  2     Web Service A      Mike             Delivered
  3     WPF Job 2          Amy              In Progress
  4     Test Job 1         Brian            Delivered
  </code></pre>
  
  <p>When a status row is updated with 'Delivered' (again, any of the 30 people working on this workbook can change the status), is it possible for a VBA macro so fire off an email to (in this example) Mike and Brian saying 'Your work items have been delivered'?</p>
  
  <p>My concern is that there are so many hands stirring the pot, so to speak, that it's not practical to automate the notification process based on the workbook being updated.</p>
  
  <p>Is it worth pursuing or should I forgo this altogether?</p>