Send mail problem in Office 2003

[Henrich]

I have made a code that has automaticly send workbook as attachment via Lotus
Notes v6.5.4 in Office2000 and everything is OK
ActiveWorkbook.SendMail Recipients:="" & osoba & "", Subject:="Uverovy
prislub " & customer, ReturnReceipt:=True

but when I run this code under Office 2003 I get this error message: Run
time error '1004' - Method 'SendMail' of object '_Workbook' failed.

Why?! Lotus is set as default mail client

 

[Ron de Bruin]

Hi Henrich

Why?! Lotus is set as default mail client

Also here

Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.

See also this site for Lotus examples
http://www.excelkb.com/?cNode=1X5M7A

 

[Henrich]

Hi Ron,

THNX for your answer but I didn't mean to send a workbook from Lotus but
from Excel.
When I'm working in Excel 2000 I fill some forms, then I click OK button and
then will be automaticly send filled activeworkbook from Excel as attachmend.
But When I'm working in Excel 2003 I get that error message.

I don't want to do any codes in Lotus, just click OK button as in Excel 2000
and the mail should be sent to recipient.

 

[Henrich]

Hi Ron,

so after spent a few hours on searching for answer of my problem I have find
the right answer ->
http://support.microsoft.com/kb/834008/en-us#XSLTH3124121123120121120120

After adding new keys from link above everything is working well.

 

[Ron de Bruin]

Thanks for the feedback