title: Add image from Excel sheet to Outlook HTML body using Excel VBA
body: <p>I am trying to add an image from an Excel sheet to an Outlook email.</p>
  
  <p>I tried using a link to an image stored in a network location and on the Internet. However, not all users will have access to these locations.</p>
  
  <p>Is it possible to store the image in another worksheet and then copy it into the email body?</p>
  
  <p>I know the below won't work because you can't export shapes but can I do something like this?</p>
  
  <pre><code>ActiveUser = Environ$("UserName")
  TempFilePath = "C:\Users\" &amp; ActiveUser &amp; "\Desktop\"
  
  Sheets("Images").Shapes("PanelComparison").Export TempFilePath &amp; "\PanelComparison.png"
  panelimage = "&lt;img src = ""TempFilePath\PanelComparison.png"" width=1000 height=720 border=0&gt;"
  </code></pre>