M
mfrisbyuk via AccessMonster.com
Hi
I am trying to setup a button that will select a report and attact it as a
excel file to a email in access 2000
when you click the button it will ask which team leader do you want, you type
in a name and then it transfers to outlook ok, but when you have done it once,
you can send another email as you get an error message "The SendObject action
was canceled."
below is the click button Information
Any help on this would be greatful
Mark
Private Sub Marx_Click()
On Error GoTo Err_Marx_Click
Dim stDocName As String
DoCmd.SendObject acReport, stDocName, acFormatXLS, , , , "Marx 2
UserName/Password Needed.", "Please find a full list of everyone in my team
that does not have Marx 2 UserName or Password.", -1
Exit_Marx_Click:
Exit Sub
Err_Marx_Click:
MsgBox Err.Description
Resume Exit_Marx_Click
End Sub
I posted this add before and tracey advised to add -1 in the Editmessage
Parameter i did that
but still the same error.
it looks like the button does not refresh its self also i am not getting the
same error with access 2003 could this be a problem with access 2002.
any ideas??
Thanks
Mark
I am trying to setup a button that will select a report and attact it as a
excel file to a email in access 2000
when you click the button it will ask which team leader do you want, you type
in a name and then it transfers to outlook ok, but when you have done it once,
you can send another email as you get an error message "The SendObject action
was canceled."
below is the click button Information
Any help on this would be greatful
Mark
Private Sub Marx_Click()
On Error GoTo Err_Marx_Click
Dim stDocName As String
DoCmd.SendObject acReport, stDocName, acFormatXLS, , , , "Marx 2
UserName/Password Needed.", "Please find a full list of everyone in my team
that does not have Marx 2 UserName or Password.", -1
Exit_Marx_Click:
Exit Sub
Err_Marx_Click:
MsgBox Err.Description
Resume Exit_Marx_Click
End Sub
I posted this add before and tracey advised to add -1 in the Editmessage
Parameter i did that
but still the same error.
it looks like the button does not refresh its self also i am not getting the
same error with access 2003 could this be a problem with access 2002.
any ideas??
Thanks
Mark