See
http://www.rondebruin.nl/cdo.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Zigball" wrote in message oups.com...
I am fairly new to vba and I have found that vba is the greatest thing
in ms excel, wow. Anyway I appriceate everybodies help. I am trying to
email excel sheets using vba and not using outlook or any ms email
application. Does anyone have the code to simply email documents as
attachments possibly on a schedule? If not I will settle for any help
pretaining to the subject.