Auto Email

[Guest]

I'm guessing that this is a programming question.

I'd like to know if it's possible to have Access automatically notify some
via email after a specific field has been updated.

Is this possible?

If yes, please explain with detail because I'm still learning VBA.

 

[fredg]

I'm guessing that this is a programming question.

I'd like to know if it's possible to have Access automatically notify some
via email after a specific field has been updated.

Is this possible?

If yes, please explain with detail because I'm still learning VBA.

On your form, code the control's AfterUpdate event:

DoCmd.SendObject acSendNoObject, , acFormatTXT,
"(e-mail address removed)", , , "Changes made", "some text here", True

Change True to False to send the email without first displaying it for
editing.

 

[Guest]

Thanks Fredg, That sounds sooo easy!

On your form, code the control's AfterUpdate event:

DoCmd.SendObject acSendNoObject, , acFormatTXT,
"(e-mail address removed)", , , "Changes made", "some text here", True

Change True to False to send the email without first displaying it for
editing.

 

[Guest]

Hi Fredg,
I tried this code
DoCmd.SendObject acSendNoObject, , acFormatTXT,

"(e-mail address removed)", , , "Changes made", "some text here", True

Change True to False to send the email without first displaying it for
editing.

but it's still display for editing. Why?

 

[fredg]

Hi Fredg,
I tried this code
DoCmd.SendObject acSendNoObject, , acFormatTXT,
but it's still display for editing. Why?

Please copy and paste your EXACT code into a reply message so I can
see it.

 

[Guest]

DoCmd.SendObject acSendNoObject, , acFormatTXT, "(e-mail address removed)," &
"(e-mail address removed)," & "(e-mail address removed)", , "(e-mail address removed)," & "(e-mail address removed)",
"Blah blah", Text Message_
& vbNewLine & Text Message , False

 

[fredg]

DoCmd.SendObject acSendNoObject, , acFormatTXT, "(e-mail address removed)," &
"(e-mail address removed)," & "(e-mail address removed)", , "(e-mail address removed)," & "(e-mail address removed)",
"Blah blah", Text Message_
& vbNewLine & Text Message , False

You have incorrectly written the multiple email addresses.
Adapt this. It works for me.

DoCmd.SendObject acSendNoObject, , acFormatTXT, _
"(e-mail address removed),[email protected],[email protected]", _
, , "Test", "TextMessage" & vbNewLine & "More Text", False

Note how I have 3 addresses (separated by commas) in the To argument
position but the entire argument is within one set of quotes:
"(e-mail address removed),[email protected],[email protected]"

compare the above with what you had:

"(e-mail address removed)," & "(e-mail address removed)," & "(e-mail address removed)
Should have been:
"(e-mail address removed), (e-mail address removed), (e-mail address removed)"

The same applies with the cc and bc arguments.

 

[Guest]

Fredg,
Thank you for your help.
I tried the way you show me, but the email still stairing at me and not auto
send out.

note: we use lotus note, is that have anythign to do with?