View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Send mail problem in Office 2003

Hi Henrich

Why?! Lotus is set as default mail client

Also here

StartSettingsControl 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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Henrich" wrote in message ...
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