Link to home
Start Free TrialLog in
Avatar of wiggs1006
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!
ASKER CERTIFIED SOLUTION
Avatar of mladenovicz
mladenovicz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mladenovicz
mladenovicz

dim email
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
Or if you don't want to use CDO, try this
http://www.developersdomain.com/vb/articles/smtp.htm