Thread: Email automatically every time you print document
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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.



Reply With QuoteReply With Quote