title: using vba to send a chart in html form through outlook
body: <p>I am using vba to send a chart in an html formatted email to outlook. The issue is only I am able to see the chart, none of the recipients can view it.</p>
  
  <p>Fname = Environ$("temp") &amp; "\Chart1.jpg"</p>
  
  <pre><code>ActiveWorkbook.Worksheets("eod summary").ChartObjects("Chart 1").Chart.Export _
          Filename:=Fname, FilterName:="JPG"
  
  With OutMail
      .To = "first.lastname@aol.com"
      .CC = ""
      .Subject = h
      .Attachments.Add Fname
  
      s = "&lt;p&gt;&lt;img src=" &amp; Fname &amp; "&gt;&lt;/p&gt;"
      s = "&lt;HTML&gt;&lt;BODY&gt;&lt;CENTER&gt;" &amp; s &amp; "&lt;/CENTER&gt;&lt;HTML&gt;&lt;BODY&gt;"
  
      .HTMLBody = RangetoHTML(rng) &amp; s &amp; RangetoHTML(rng2)
  
      .Display
      .Send
  
  End With
  </code></pre>
  
  <p>I am saving the file to my temp folder. There is a shared server that the recipients use, however not everyone refers it as the same drive (Z drive for some G drive for others). Therefore, I was unsuccessful when I tried retrieving the image from that filepath.</p>
  
  <p>any help greatly appreciated!</p>