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 Thu, 11 Jan 2007 16:14:00 -0800, Nanette wrote:

> 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 Removed)", , , "Changes made", "some text here", True

Change True to False to send the email without first displaying it for
editing.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thanks Fredg, That sounds sooo easy!

"fredg" wrote:

> On Thu, 11 Jan 2007 16:14:00 -0800, Nanette wrote:
>
> > 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 Removed)", , , "Changes made", "some text here", True
>
> Change True to False to send the email without first displaying it for
> editing.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

Hi Fredg,
I tried this code
DoCmd.SendObject acSendNoObject, , acFormatTXT,
> "(E-Mail 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?

On Mon, 19 Feb 2007 11:37:15 -0800, dangthanh wrote:

> Hi Fredg,
> I tried this code
> DoCmd.SendObject acSendNoObject, , acFormatTXT,
>> "(E-Mail 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?

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

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

DoCmd.SendObject acSendNoObject, , acFormatTXT, "(E-Mail Removed)," &
"(E-Mail Removed)," & "(E-Mail Removed)", , "(E-Mail Removed)," & "(E-Mail Removed)",
"Blah blah", Text Message_
& vbNewLine & Text Message , False

"fredg" wrote:

> On Mon, 19 Feb 2007 11:37:15 -0800, dangthanh wrote:
>
> > Hi Fredg,
> > I tried this code
> > DoCmd.SendObject acSendNoObject, , acFormatTXT,
> >> "(E-Mail 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?
>
> Please copy and paste your EXACT code into a reply message so I can
> see it.
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

On Tue, 20 Feb 2007 12:15:00 -0800, dangthanh wrote:

> DoCmd.SendObject acSendNoObject, , acFormatTXT, "(E-Mail Removed)," &
> "(E-Mail Removed)," & "(E-Mail Removed)", , "(E-Mail Removed)," & "(E-Mail Removed)",
> "Blah blah", Text Message_
> & vbNewLine & Text Message , False
>
> "fredg" wrote:
>
>> On Mon, 19 Feb 2007 11:37:15 -0800, dangthanh wrote:
>>
>>> Hi Fredg,
>>> I tried this code
>>> DoCmd.SendObject acSendNoObject, , acFormatTXT,
>>>> "(E-Mail 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?
>>
>> Please copy and paste your EXACT code into a reply message so I can
>> see it.
>>
>> --
>> Fred
>> Please respond only to this newsgroup.
>> I do not reply to personal e-mail
>>


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

DoCmd.SendObject acSendNoObject, , acFormatTXT, _
"(E-Mail Removed),(E-Mail Removed),(E-Mail Removed)", _
, , "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 Removed),(E-Mail Removed),(E-Mail Removed)"

compare the above with what you had:

"(E-Mail Removed)," & "(E-Mail Removed)," & "(E-Mail Removed)
Should have been:
"(E-Mail Removed), (E-Mail Removed), (E-Mail Removed)"

The same applies with the cc and bc arguments.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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?

"fredg" wrote:

> On Tue, 20 Feb 2007 12:15:00 -0800, dangthanh wrote:
>
> > DoCmd.SendObject acSendNoObject, , acFormatTXT, "(E-Mail Removed)," &
> > "(E-Mail Removed)," & "(E-Mail Removed)", , "(E-Mail Removed)," & "(E-Mail Removed)",
> > "Blah blah", Text Message_
> > & vbNewLine & Text Message , False
> >
> > "fredg" wrote:
> >
> >> On Mon, 19 Feb 2007 11:37:15 -0800, dangthanh wrote:
> >>
> >>> Hi Fredg,
> >>> I tried this code
> >>> DoCmd.SendObject acSendNoObject, , acFormatTXT,
> >>>> "(E-Mail 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?
> >>
> >> Please copy and paste your EXACT code into a reply message so I can
> >> see it.
> >>
> >> --
> >> Fred
> >> Please respond only to this newsgroup.
> >> I do not reply to personal e-mail
> >>
>
>
> You have incorrectly written the multiple email addresses.
> Adapt this. It works for me.
>
> DoCmd.SendObject acSendNoObject, , acFormatTXT, _
> "(E-Mail Removed),(E-Mail Removed),(E-Mail Removed)", _
> , , "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 Removed),(E-Mail Removed),(E-Mail Removed)"
>
> compare the above with what you had:
>
> "(E-Mail Removed)," & "(E-Mail Removed)," & "(E-Mail Removed)
> Should have been:
> "(E-Mail Removed), (E-Mail Removed), (E-Mail Removed)"
>
> The same applies with the cc and bc arguments.
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>