Email Notification of updated record information

[eyost]

Hi all,

I have a database that I would like to incorporate the ability to automatically send me the current record via email once a particular field has been changed. For example, I have a field named DateFinished. I would like to have it automatically email me the record when a date has been entered in that particular field.

Any ideas?

Ed

 

[mikec]

Ed,

You'd need to do this through a form. In the AfterUpdate event of the DateFinished, you'll want to use the SendObject method, which is explained in the VB help.

Mike

 

[Talismanic]

Here is a sample of the SendObject:

DoCmd.SendObject , , , Me.Email, , , Me.Subject, "TextToSend", True

This assumes that the Email and subject are going to be pulled from the database. Just rename the Me.Email and Me.Subject to match your controls name. You could also do the same thing with the "TextToSend" field. If you change the true at the end to a false the email will automaticaly be sent without a promt from the sender.

There are a lot of different arguments that you can use with send email, it sounds like you want the email to allways be sent to you. In that case change the Me.Email to "YourEmailAddress" <---- Don't forget the quotes. The same applies to the subject.

Now to get the text in the control in the message part of your email you can use Me.YourText field in place of the "TextToSend".

If you want to see a thread that covers this topic and includes a couple of advanced techniques, check this thread.

Topic: Email Report using only Current Record