Look here Andy
http://www.rondebruin.nl/mail/prevent.htm


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


"andycharger " wrote in message ...
Thanks.
However, I notice that the system asks a lot of questions such as
choose your email client, etc....

Is there a way to just send the email automatically without human
intervention?

I have used application.displayalerts = false before but not sure if
this is enough for emailing.


Code:
--------------------

Sub Mail_workbook_1()
ActiveWorkbook.SendMail ", _
"subject goes here"
End Sub

--------------------



---
Message posted from http://www.ExcelForum.com/