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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top