VBA notification
- Thread starter Afarag
- Start date
Using the code described here:
http://www.rondebruin.nl/win/s1/outlook/bmail4.htm
You'll want to use the Workbook_Open event. In the ThisWorkbook module, I'd put something like
to run whatever macro you build to send the actual email.
http://www.rondebruin.nl/win/s1/outlook/bmail4.htm
You'll want to use the Workbook_Open event. In the ThisWorkbook module, I'd put something like
Code:
Private Sub Workbook_Open()
Call MyMailMacro
End SubDear Luke 
it's Great work, but i want a progress option, that i want follow my worksheet automatically without the user activate the required macro, that i want a report that notify my about the users who open this worksheet, i want this macro notify me about the users by his PC account username
it's Great work, but i want a progress option, that i want follow my worksheet automatically without the user activate the required macro, that i want a report that notify my about the users who open this worksheet, i want this macro notify me about the users by his PC account username
Afarag,
The Event macro that I posted would get triggered automatically, no need for the user to activate the macro.
If you need info about the user, you could capture that info via
The link I posted shows you how to send the email.
Note that the user will be aware that an email is being sent. Sending email from a persons computer w/o their knowledge at some level is considered a type of trojan, so there are several built in security features that will get alerted. The most common work-around is that the user sees a pop-up informing them that a macro is trying to send an email, and they just have to click "ok" to allow it.
The Event macro that I posted would get triggered automatically, no need for the user to activate the macro.
If you need info about the user, you could capture that info via
Code:
MyString = Application.UserNameNote that the user will be aware that an email is being sent. Sending email from a persons computer w/o their knowledge at some level is considered a type of trojan, so there are several built in security features that will get alerted. The most common work-around is that the user sees a pop-up informing them that a macro is trying to send an email, and they just have to click "ok" to allow it.