title: Automation email in Excel
body: <p>I am trying to design an excel file that will help my company with recruitment.</p>
  
  <p>The task is to create a sheet for candidates that the company speaks to, we will record all the records for the candidates including their first name, last name, mobile and email address. You can see a screenshot of how everything looks here: <a href="https://imgur.com/gallery/tvAIx" rel="nofollow noreferrer">https://imgur.com/gallery/tvAIx</a> </p>
  
  <p>As you can see there are columns for when the company speaks to the candidate and when he sends his CV to us. At the end there is also a "CV reminders" column. It has the following code <code>=IF(ISBLANK(F2), HYPERLINK("mailto:" &amp; D2 &amp; "?subject=" &amp; $O$3 &amp; "&amp;body=" &amp; $P$3, "Send reminder"), "All good")</code></p>
  
  <p>The idea is so that if CV has not been received yet, you can press the cell and it will generate a reminder email for the candidate. I want to make all the process autonomous so that it can pick out the candidate name from the relevant cell and send him a generic email like: </p>
  
  <p>"Hi <em>name from cell</em>, </p>
  
  <p>Hope you are well.</p>
  
  <p>We have spoken with you on <em>date from cell</em>. Have you had a chance to review your CV yet? Do you have any questions?"</p>
  
  <p>I am sure it is possible with VBA just don't know how. Thank you.</p>