Email automatically every time you print document
 

I was wondering if anyone knew if it is possible to email a worksheet
everytime you print it

If anyone could help me I would really appreciate it.

Email automatically every time you print document
 

Hi

There is a beforeprint event that you can use in the Thisworkbookmodule

Private Sub Workbook_BeforePrint(Cancel As Boolean)
macronameofmailmacro
End Sub

Look here for a mail macro
http://www.rondebruin.nl/sendmail.htm

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


"troberson78" wrote in message oups.com...
I was wondering if anyone knew if it is possible to email a worksheet
everytime you print it

If anyone could help me I would really appreciate it.