
Automatically Emailing Data from MS Access to MS Outlook
Here is what I use to send an e-mail via Outlook or Exchange
Private Sub EmaiReportButton_Click()
On Error GoTo Err_EmaiReportButton_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Dim stDocName As String
stDocName = "IssueReport"
'DoCmd.SendObject acReport, stDocName
DoCmd.Save
DoCmd.SendObject acSendReport, "IssueReport", acFormatTXT, _
Form_IssueTable.KeyPerson, , , _
"A New EMIS Exception Issue", , False, False
Exit_EmaiReportButton_Click:
Exit Sub
Err_EmaiReportButton_Click:
MsgBox Err.Description
Resume Exit_EmaiReportButton_Click
End Sub
James A. Taylor Jr.