E-mail field to open email with address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got the e-mail to open with the correct e-mail address, also got rid of the
error message. Now I would like to be able to add a report to the e-mail
automatically! Please help!
Any codes you know that will attach a report to this e-mail will be helpful!
I knwo how to do it using a macro, but I need to go the other way around,
opening an e-mail with the address on the field, etc etc etc
 
Just in case, this is the code I use toopen the e-mail and get rid of the
error message.

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

What I need the database to do, is attach a report to this e-mail. Also I do
have the report working and it opens only the current report I need to see,
so it is linked. I think it is called "As String"?!
Thanks so much!
David
 
Back
Top