View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abel Chan Abel Chan is offline
external usenet poster
 
Posts: 2
Default Cannot send out Excel workbook through Outlook Express

Hi all,

I was trying to send out an excel workbook through Outlook Express.

I looked at http://www.rondebruin.nl/ and have:
Workbooks.Application.ActiveWorkbook.SendMail ", _
"This is a test"
In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
failed"

I checked my Internet Option | Program and it has Outlook Express as the
default Email.

Any idea why?

Thanks so much.

Abel Chan