Private sub AutoEmail()

ActiveWorkbook.SendMail "

end sub

This works for me!

The only trouble is, is that outlook must be open or they won't send, I use
this daily to send to 50 people and never get a message

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1