H
Hulk
How can I modify the event below for sending only one report which is being
viewed to E mail? I can't seem to make a long event work that was suggested
earlier.
Access 2002
Form Name is Memos Add, report Name is Memos
Has a ID Field that is an autonumber for the primary key
Private Sub Email_Report_Click()
On Error GoTo Err_Email_Report_Click
Dim stDocName As String
stDocName = "Memos"
DoCmd.SendObject acReport, stDocName
Exit_Email_Report_Click:
Exit Sub
Err_Email_Report_Click:
MsgBox Err.Description
Resume Exit_Email_Report_Click
End Sub
This command button sends all records to e mail by report, I want to send
just the current form to E-mail.
Thank you in advance for any help.
Bill Frederick
viewed to E mail? I can't seem to make a long event work that was suggested
earlier.
Access 2002
Form Name is Memos Add, report Name is Memos
Has a ID Field that is an autonumber for the primary key
Private Sub Email_Report_Click()
On Error GoTo Err_Email_Report_Click
Dim stDocName As String
stDocName = "Memos"
DoCmd.SendObject acReport, stDocName
Exit_Email_Report_Click:
Exit Sub
Err_Email_Report_Click:
MsgBox Err.Description
Resume Exit_Email_Report_Click
End Sub
This command button sends all records to e mail by report, I want to send
just the current form to E-mail.
Thank you in advance for any help.
Bill Frederick