title: How to hide sender email id while sending email by CDO in excel vba
body: <p>I want to hide <strong>senders email ID</strong> but not the <strong>recipient name</strong> like below </p>
  
  <p><a href="https://i.stack.imgur.com/y1ysM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y1ysM.png" alt="enter image description here"></a></p>
  
  <p>Below is part of my script to send email by <strong>CDO</strong></p>
  
  <pre><code>With iMsg
      Set .Configuration = iConf
      .To = "open.dealerz@gmail.com"
      .CC = ""
      .BCC = ""
      .From = "Dealer &lt;open.dealerz@gmail.com&gt;" 
      .Subject = "Test"
      .TextBody = ""
      .Send
  End With
  </code></pre>