D
distance
I would like to know how to email a report in access 2003????
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
You can add a button to a form and use the button wizard to email a report
when the button is clicked. The wizard will do all the work for you. The
code created by that wizard (in case you want to do it some other way) looks
like this:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
Dim stDocName As String
stDocName = "Designs"
DoCmd.SendObject acReport, stDocName
Exit_Command15_Click:
Exit Sub
Err_Command15_Click:
MsgBox Err.Description
Resume Exit_Command15_Click
End Sub
when the button is clicked. The wizard will do all the work for you. The
code created by that wizard (in case you want to do it some other way) looks
like this:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
Dim stDocName As String
stDocName = "Designs"
DoCmd.SendObject acReport, stDocName
Exit_Command15_Click:
Exit Sub
Err_Command15_Click:
MsgBox Err.Description
Resume Exit_Command15_Click
End Sub
B
Bruce
Just click on File/Send/RTF , thats it.
J
jahoobob via AccessMonster.com
It should be File/Send to/Mail recpient/RTF. If you want to maintain the
fromatting of the report select Snapshot instead of RTF
fromatting of the report select Snapshot instead of RTF
M
MarieK
I simply right click on the report (in the data access page)..."SEND TO" and
use my groupwise...
use my groupwise...