Field on a Form to attach a Report in an email when double clicked

[DavidGuaman]

I have the following code on my form, this field is for an e-mail and uses
the following code which works great. I would like the e-mail to
automatically pick a report already created and linked to the current record
on the form.
I know how to do this with a macro, but the macro wont populate the e-mail
address from the field on my form, so please help!!!

Private Sub e_mail_DblClick(Cancel As Integer)
On Error GoTo Err_Handler

DoCmd.SendObject acSendNoObject, To:=Me.

Exit_Handler:
Exit Sub

Err_Handler:
If Err.NUMBER <> 2501 Then
MsgBox "Error " & Err.NUMBER & " - " & Err.Description
End If
Resume Exit_Handler
End Sub