Email notification?

[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

 

[jatfill]

1. Create a report based on the record on the form you are wanting to do this from.

2. Create a macro with the SendObject command in it(I would put a null condition in case someone removes the date on the form). Fill in the information at the bottom (to address, subject, message text, etc.)

3. On the DateFinished field, update the AfterUpdate property to start the macro & send the email.