hi Sly101

See
http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sly101" wrote in message ...
Hi, what I'm looking for is a macro that will save a worksheet as a new
workbook with whatever customer name in a cell in this said worksheet and
then email the new workbook, all by on click. I'm trying to keep this sheet
as dummy proof as possible.
Thanks