Hi Jonathan

and outlook is the default mail program

Is this a typo?

If not change it to Outlook Express
StartSettingsControl Panel....Internet options (Program Tab)
Close Excel first before you make a change.




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


"Jonathan" wrote in message news:Xejdc.23646$J56.12915@edtnps89...
Thanks for the quick response....

I am using this exact code

ActiveWorkbook.SendMail ", "This is the Subject line"

and have tried

Application.Dialogs(xlDialogSendMail).Show "), ("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


"Ron de Bruin" wrote in message
...
Hi Jonathan

You can use this example from my site
http://www.rondebruin.nl/sendmail.htm#Workbook

You only can send a workbook that is open if you want to
use code that will work in both programs


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


"Jonathan" wrote in message
news:uridc.23608$J56.13776@edtnps89...
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