I like to open a folder,auto print,save then close
 

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?

I like to open a folder,auto print,save then close
 

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?

I like to open a folder,auto print,save then close
 

each fax,e-mail goto someone differnt. currently I use a fax server and I
embed to fax numbers but I still must open all of them and send it to the
server one at a time by a addin button then save and close each one before I
move to the next one.The e-mail are allmost the some a little faster not
much.So I'm try to find a way to make all this automatice.

"Tom Ogilvy" wrote:

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?