Sorry if this has already been answered but I was unable to find it...
I have a button on a Form that I want to email a Report from. The problem is that the Report is always an attachment. Is there an easy way to make the report appear in the body instead of as attachment?
Here is what I currently have:
Thanks.
I have a button on a Form that I want to email a Report from. The problem is that the Report is always an attachment. Is there an easy way to make the report appear in the body instead of as attachment?
Here is what I currently have:
Code:
Private Sub Report_test_Click()
On Error GoTo Err_Report_test_Click
Dim stDocName As String
stDocName = "Sample Receipt Notification Report"
DoCmd.SendObject acSendReport, stDocName, acFormatRTF, Me.Email, , , "MAS Sample Receipt Notification"
Exit_Report_test_Click:
Exit Sub
Err_Report_test_Click:
MsgBox Err.Description
Resume Exit_Report_test_Click
End Sub
Thanks.