Thread: Excel vb Email
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Excel vb Email


Do you get errrors?


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


"Jonathan" wrote in message news:Ufjdc.23647$J56.9657@edtnps89...
sorry I meant to say outlook express is the default program not outlook

"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