Getting e-mail to work on update for new field on old listin

Getting e-mail to work on update for new field on old listin

I have an application with a lot of data. I added a new field a couple of days ago, and I want an e-mail to be sent out when that new field is updated to the status "yes".

The e-mail seems to be working fine for new records, that were entered into the database after I added the field. However, the e-mail does NOT work for old records when I set the status of that new field to "yes."

Any ideas how I can make this work for old records too?
sharonm