This is the format that sends the email:
DoCmd.SendObject acSendNoObject, , acFormatTXT, sTo, , , sSubjectMsg, sMsg,
False
where:
sTo is the email address
sSubjectMsg is the subject message
sMsg is the actual message
You could put this in a command button click event or the after update event
of a txt field on your form.
To get mail sent to several people you will need to change the sTo variable
for each instance.
