LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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:




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send email from vba code in excel Melisa Hutchins Excel Discussion (Misc queries) 1 May 1st 10 05:48 PM
Code to send a email via Macro in excel Sunil Somani[_2_] Excel Discussion (Misc queries) 1 September 30th 09 08:28 AM
Please help VBA code not working properly send email when due dates Tia[_3_] Excel Worksheet Functions 0 July 21st 09 08:37 AM
Code to send email to address within selection in Excel workbook vic1 Excel Discussion (Misc queries) 3 May 28th 08 09:51 PM
VBA code to send range automatically via email Carl Excel Programming 1 June 29th 04 07:00 PM


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"