Macros

[Lynne]

Hi..
Wld like to know if it is possible to do the following:
Schedule an autodownloaded xl file to be zipped and mailed to a group of
receivers??
.... if yes, how...
If am in the wrong forum or if it has been addressed previously please
revert too.
Lyn

 

[Dave Peterson]

Ron de Bruin has a bunch of code for mailing workbooks within excel.

He even has some that zip it.

http://www.rondebruin.nl/sendmail.htm#Zip

(and look around for other examples)

 

[Lynne]

Thanks Dave that that useful link./Lynne

Ron de Bruin has a bunch of code for mailing workbooks within excel.

He even has some that zip it.

http://www.rondebruin.nl/sendmail.htm#Zip

(and look around for other examples)