Send mail, need help

  • Thread starter Thread starter Paul B
  • Start date Start date
P

Paul B

Just put excel 2002 SP3 on a computer at work, and when I try to run this
code I get
Run time error 1004 method 'sendmail of object'_workbook failed

Sub Mail_workbook()
ThisWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub

Also in the help file it says to:
Send the entire workbook as an attachment
On the File menu, point to Send To, and then click Mail Recipient (as
Attachment).

I do not have Mail Recipient (as Attachment)

Running windows 98SE with outlook express 6 on this computer
Thanks for the help
Paul B
 
Ron, I had a MAPI=1, added MAPIX=1 below it and it now works! Thanks, do I
need to delete the MAPI=1? Thanks again
Paul B
 
Hi Paul

Will you please tell me what you do.

Did you install a clean install of Win 98 and after that
Office 2000 Sp3 ?

Please tell us
 
Ron, we had excel 97 on this computer, uninstalled it and did a clean
install of 2002, also when I run the code I get a message form outlook
express asking would you like to send the message, is there anyway to avoid
this?
Paul B
 
Back
Top