Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send report as body

Status
Not open for further replies.

bw2601

Technical User
Dec 16, 2004
29
US
Does anyone know how to send a report in the body of an email. this is the code i am using currently, but it will only send the report as an attachment.

Private Sub Mail_CallDescription_Click()
On Error GoTo Err_Mail_CallDescription_Click

If Me.Emailed = True Then
DoCmd.GoToControl "Call ID"
Me.Mail_CallDescription.Visible = False
Else
Me.Mail_CallDescription.Visible = True

Dim stDocName As String

stDocName = "Email_Ticket"
DoCmd.SendObject acReport, stDocName, , , Brandiew
DoCmd.GoToControl "Call ID"
Me.Emailed = True
Me.Mail_CallDescription.Visible = False

End If

Exit_Mail_CallDescription_Click:
Exit Sub

Err_Mail_CallDescription_Click:
MsgBox Err.Description
Resume Exit_Mail_CallDescription_Click

End Sub


any help someone can give me would be greately appreicated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top