View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcello do Guzman[_2_] Marcello do Guzman[_2_] is offline
external usenet poster
 
Posts: 1
Default Possible to write VBA code to send out an EMAIL everytime a workbook is opened?

I would like to add in ThisWorkbook the code so that an email is sent
out to me each time a certain workbook is opened. This is a way for me
to know who is using the Excel application I developed.

Example:
-------------

Customer X buys my application. He installs the application on his
computer and opens the workbook. This sends an email to me with the
message. "User X opened TestMarket.xls"

If Customer X should make copies of my application and give them to
his friends an email would also be sent to me with the above message.
However, the email address from the sender would be different.

This is a sneaky way for me to know who is using my application. Is it
also possible to tell OUTLOOK and/or OUTLOOK EXPRESS not to save a
copy of the sent email?

Any help would be greatly appreciated.

sincerely,



Marcello

email: