title: Excel Macro send email
body: <p>i have a report that i would like to send via excel.
  it will include the recipitents, subject and the information in the body. actually it could copy the cells in question.
  what i did so far is create a button and assign a macro to it with this code:</p>
  
  <pre><code>Private Sub CommandButton1_Click()
   Application.Dialogs(xlDialogSendMail).Show arg1:=Sheets("Sheet1").Range("E3"), _
                        arg2:=Sheets("Sheet1").Range("E7")
  
  End Sub
  </code></pre>
  
  <p>the problem is that this command sends the workbook as attachment.</p>
  
  <p>can someone help me with the code that will allow me to do this.</p>
  
  <p>thanks a million!</p>
  
  <p>cheers</p>