Sure, here is the code you need....
Private Sub MailReport_Click()
On Error GoTo Err_MailReport_Click
Const conErrCancel = 2501
Dim stDocName As String
stDocName = "Billing"
DoCmd.SendObject acSendReport, stDocName, acFormatRTF, "Name of
Recipent", , , "Subject of Email"
DoCmd.Close acForm, "Billing"
If Err.Number = conErrCancel Then
MsgBox ("You chose to Cancel the option"), vbQuestion
Let me know if you need other information.
From: robert mccafferty [mailto:rmccafferty@e...]
Sent: Wednesday, December 27, 2000 10:54 AM
Subject: Link to Outlook
We have all seen Contact Us buttons on web sites that, when you click
them, open an email form already addressed to the host company.
In Access, is there any reasonable way that an email can automatically be
opened, addressed to the email address in the email field, in Outlook?
(Via a hyperlink field or a command button or any other method that is not
You are currently subscribed to vba_access as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-vba_access-$subst('Recip.MemberIDChar')@p2p.wrox.com