-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Send email based upon a particular user opening the file
- Thread starter gruple
- Start date
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
Welcome to the board.
The gist of what you're trying to do is, in the ThisWorkbook module, put:
Private Sub Workbook_open
if application.username = "gruple" then
' insert code to send e-mail here
end if
end sub
There are several examples for how to send mail via VBA on the board, with one of the sites referenced being:
http://www.j-walk.com/ss/excel/tips/tip86.htm
HTH
The gist of what you're trying to do is, in the ThisWorkbook module, put:
Private Sub Workbook_open
if application.username = "gruple" then
' insert code to send e-mail here
end if
end sub
There are several examples for how to send mail via VBA on the board, with one of the sites referenced being:
http://www.j-walk.com/ss/excel/tips/tip86.htm
HTH
Upvote
0
Similar threads
- Solved
