Hi Marcello

Ron de Bruin has code for sending email at
http://www.rondebruin.nl/
but how this works out will depend a lot on the users' email client and
their security settings; this behavior is similar to what annoying viruses
do so I doubt you can do this "invisible and untraceable" without problems.

HTH. best wishes Harald

"Marcello do Guzman" skrev i melding
...
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: