Send mail, need help

[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 de Bruin]

Hi Paul

Will you check out your win.ini file and post back
http://support.microsoft.com/default.aspx?scid=kb;en-us;296396

 

[Ron de Bruin]

Or maybe Outlook is your default Mail program and not OE

Check out if Outlook or Outlook Express is your mail program for Office
Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.

http://support.microsoft.com/default.aspx?scid=kb;en-us;821404
OFF: You Cannot Send E-Mail from Microsoft Word, Microsoft PowerPoint, or
Microsoft Excel

 

[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

 

[Ron de Bruin]

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 de Bruin]

Don't delete MAPI=1 Paul

 

[Paul B]

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

 

[Ron de Bruin]

Hi Paul

Yes, you use the right program<g>
http://www.rondebruin.nl/sendmail.htm#Prevent

Thanks for the feedback