Look at CDO (Colabrative Data Objects) on Ron's web site...

http://www.rondebruin.nl/cdo.htm
--
HTH...

Jim Thomlinson


"Zigball" wrote:

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?