have you tried turning on the vba recorder and then FileSend ToRecipient

then looking at the code?


" wrote:

I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3) I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony