Can you save each sheet in a workbook separately?

[Angela]

I'm trying to make this easy, and we need to send worksheets through email,
and I don't want to have to re-do or copy and save each worksheet.

Thanks!

 

[Bernard Liengme]

I think Ron can help at
http://www.rondebruin.nl/sendmail.htm
best wishes

 

[Ron de Bruin]

For the Op

Yes i have code for this on my site

See also the mail templates from my site

If you have 2007 I have a new version (beta)
If you want to test that one let me know

I think Ron can help at
http://www.rondebruin.nl/sendmail.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email






__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com