title: Ms Access Send Email with Report as Attachment
body: <p>Using VBA code builder in MS Access, I have been able to write code that opens Outlook and send me an email with the click of a button.  I am having problems with adding an attachment. Most code I have found adds files outside the MS Database as an attachment, I would like to add a report created in my database as an attachment.  </p>
  
  <pre><code>Private Sub EmailReport_Click()
  Dim oApp As New Outlook.Application
  Dim oEmail As Outlook.MailItem
  
  'Email the results of the report generated
  Set oEmail = oApp.CreateItem(olMailItem)
  oEmail.To = "myemailaddress@email.com"
  oEmail.Subject = "Training Roster"
  oEmail.Body = "Roster Information"
  
  With oEmail
      .Send
      MsgBox "Email Sent"
  End With
  </code></pre>
  
  <p>I have been looking into a command similar to </p>
  
  <pre><code>oEmail.Attachments.Add Me.
  </code></pre>
  
  <p>..But, I cannot find the correct combination for adding my report.
  Thanks!! </p>