Why open the documents. You can just create an email and add them as an
attachment.

See Ron de Bruin's site for either approach:





Ron de Bruin
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/library/en...odc_xlmail.asp
http://www.rondebruin.nl/tips.htm

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm

--
Regards,
Tom Ogilvy


"tied of opening files" <tied of opening
wrote in message ...
I would like to open a folder that has about 70 excel doc. inside and
automatly send,then save and close each doc that is inside all
automatly.How
can I do this?