Hi Al,

Yes, you can modify it to work that way, but there's a few issues you should
consider first.

This code is structured to be fired if you enter "No" into any cell in
column "X". To have it fire when the workbook opens, you'll need to loop
through all the cells in column "X" to process. This means you'll be sending
emails every time the file is opened. Somehow, I don't think that's what you
want to do!

That said, you'll need some way to tell which recipients have already been
emailed.

Also, any changes you make while it's open won't get processed until you
re-open it. If the changes you make after opening affect what was emailed
when it was opened, it's already too late.

You need to be sure how you want it to work. Maybe some others here might
have additional input for your consideration.

HTH
Regards,
GS