Modify Command Button

[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.

in 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. Thank you in
advance for any help.



Bill Frederick