wiggs1006
asked on
VBA Code to send a simple message that an Update has been added.
Can anyone help me with the code to send a message to three users that an update has been made to an excel sheet. All that the email has to contain is:
the three users
Sub. "and update has been made"
There does not have to be an attachment or anything in the message body. Thanks!
the three users
Sub. "and update has been made"
There does not have to be an attachment or anything in the message body. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or if you don't want to use CDO, try this
http://www.developersdomain.com/vb/articles/smtp.htm
http://www.developersdomain.com/vb/articles/smtp.htm
set email = createobject("cdo.message"
with email
.to = "someone@domain.com; someone1@domain.com; someone2@domain.com"
.subject = "something"
.from = "someone@domain.com"
.send
end with