title: How to send an embedded image in email from excel
body: <p>I would like to send a Excel chart in the body of an email (Outlook) (not as attachment) from VB, anyone know how to do this? </p>
  
  <p>Solved:<br>
  Just to add a bit more detail to answer below
  you'll need the following (could do with some improvement).</p>
  
  <pre><code>Sheets(2).ChartObjects(1).Chart.Export "C:\temp\Chart2.png"
  </code></pre>
  
  <p>....</p>
  
  <pre><code>   .HTMLBody = "&lt;html xmlns:o='urn:schemas-microsoft-com:office:office'" &amp; _
              "xmlns: x = 'urn:schemas-microsoft-com:office:excel'" &amp; _
              "xmlns='http://www.w3.org/TR/REC-html40'&gt; " &amp; _
              "&lt;head&gt;&lt;/head&gt;&lt;body&gt;&lt;img src='Chart2.png'&gt;&lt;/body&gt;&lt;/html&gt;"
  </code></pre>
  
  <p>and</p>
  
  <pre><code>    .Attachments.Add ("C:\temp\Chart2.png")
  </code></pre>