I have a "Shopping List" table where some users request items to be purchased (requester) and other users purchase those items (purchaser). So on any given day there may be 10 requesters requesting items to be purchased, but only one purchaser goes to buy those items. When the purchaser returns, multiple records are updated all at once (via grid edit) changing the status from "requested" to "purchased." The requesters then come pick up their items.
So I need separate notifications to go to each requester listing only their items that have been purchased. I.e.: "John, the following 4 items you requested have been purchased." "Sally, the following 10 items you requested have been purchased."
If this is not possible, it would be acceptable to have one email of all changed items go to every requester that appears on the report. I.e. "Tom, Sally, the following 14 items have been purchased." But I don't want to email every requester every day when 90% of those requesters have no purchased items on the report. (This sort of "notification spam" results in people ignoring the notifications and reverting to some other method of communication.)
Also, due to the training that would be involved, self-subscribing to a report is not an option (though I admit it would work the best...).