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?

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

**** Kuselika
www.*****-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm

--
Regards,
Tom Ogilvy


"tied of opening files" <tied of opening [email protected]>
wrote in message news:[email protected]...
> 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?

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
>
> **** Kuselika
> www.*****-clicks.com
>
> Tim Zych
> www.rubbershoe.com/olmail.htm
>
> --
> Regards,
> Tom Ogilvy
>
>
> "tied of opening files" <tied of opening [email protected]>
> wrote in message news:[email protected]...
> > 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?
>
>
>