title: Sending customised email to multiple recipients via macro
body: <p>I am trying to send an email that is customized to the recipient to over hundred recipients. </p>
  
  <p>I am able to send out my email to one person now but I have no idea how to loop it for multiple recipients and to change the content inside. </p>
  
  <p>I have something like this and it works but I have no idea how to proceed</p>
  
  <pre><code>With OutlookMailItem
  .To = Range("O2").Value
  .Subject = "Promotion campaign"
  .Body = "Dear Sir/Madam," &amp; vbNewLine &amp; vbNewLine &amp; _
          "You are eligible for &amp; Range("A2").Value &amp; _
         "Please follow the instruction below to redeem your gift" 
  </code></pre>