See my site for code examples
http://www.rondebruin.nl/sendmail.htm

Maybe you can use the templates ?


--
Regards Ron de Bruin
http://www.rondebruin.nl


"billy2willy" wrote in message
...

That is to time consuming if you have to do that for 14 different sheets
once a month, there must be an easier way.


--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=390782