Hi Les !
Got your mail, but I've been quite busy lately. I'll be answering you soon, promised !
As to your question, I would see two solutions :
1) include a check in the Query Close event that verifies the content of the ResourceName field. If it corresponds to your specific resource, then fire off a mail where required.
2) Create a scheduled agent in the Resource database that checks all newly-created documents at regular intervals. Same check as above.
If speed is required, I'd go for solution 1. Of course, that means modifying the mail template - which should always be done with utmost caution.
Cheers !
Pascal.
I've got nothing to hide, and I'd very much like to keep that away from prying eyes.