Email report error in access 2002

  • Thread starter mfrisbyuk via AccessMonster.com
  • Start date
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
 
Top