O
Ossi
I am looking for a way to send an e-mail notification
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Ed Lillis
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.
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.