Excel vb Email

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

Hello.

I am looking for some help with a function to send a workbook by email
without knowing whether the user has outlook or outlook express. I can make
the funtion work with either email program but not both. I am using Office
2000.

Thanks

Jonathan
 
Thanks for the quick response....

I am using this exact code

ActiveWorkbook.SendMail "(e-mail address removed)", "This is the Subject line"

and have tried

Application.Dialogs(xlDialogSendMail).Show ("(e-mail address removed)"), ("hi")


Both of these work in Outlook without problem but refuse to work in outlook
express (Outlook express version is 6.00) I have tried with outlook express
open and closed and outlook is the default mail program. Any hints would be
great.

Thanks

Jonathan
 
Hi Jonathan
and outlook is the default mail program
Click to expand...

Is this a typo?

If not change it to Outlook Express
Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.
 
I get the error "Runtime 1004 Show method of dialog class failed" when using
the below code

Application.Dialogs(xlDialogSendMail).Show ("(e-mail address removed)"), ("hi")

and the error "Method 'SendMail' of object '_Workbook' failed"

with the code

ActiveWorkbook.SendMail "(e-mail address removed)", "This is the Subject line"

Jonathan
 
Back
Top