VBA to send email from Access, adding report to body of email

[acerimmer]

Access 2010 - add report to body of an email

good morning,

i have VBA code to create an email and attach an excel file,

what i would like is code to add a report called REPORTMISSINGDATES to the body of the email,

this is the code i have so far, which works and adds everythng i wqant except the main body of the email

Private Sub Command31_Click()
 On Error GoTo Command31_Click_Err
 
 
Dim Email As String
 Dim name As Variant
 Dim EMPloy As Variant
 Dim month As Variant
 
month = MonthName([Forms]![STAFFATTENDANCEMenu]![StaffMonth])
 EMPloy = Forms!staffattendancezone!Staff
 name = DLookup("[STAFFNAME]", "[QRYSTAFFNAME]", "[ASA] = Forms!staffattendancezone!Staff")
 
Email = (Forms!STAFFATTENDANCEAdjust!Email)
     DoCmd.SendObject acQuery, "STAFFATTENDANCEZONECheckEmployee", "ExcelWorkbook(*.xlsx)", [email], "", "", "" & "Attendance Errors", "THIS IS WHERE I WANT THE REPORT TO GO" _
 
End Sub

[zmbd]

Please go to the bottom of this page.
Click on the Microsoft Access/VBA Insights Sitemap
Scroll down to article number 159
This contains the basics for Outlook automation.

Please keep in the following in mind:
Out right requests for full code are against site policy.
Bytes is not a code nor homework service. Please read the FAQ and posting guidelines before re-posting your question.
>> Before Posting (VBA or SQL) Code.
>> How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!.
>> POSTING_GUIDELINES: Please Read Carefully Before Posting to a Forum.