needed tapes

Is there a way to generate an email (every N days) that lists the needed 
tapes for the planned jobs ahead?

We need to automate the selection of tapes and send an email to a list 
of tape-operators.

The schedule uses tapes out of several pools and so far I write the 
"wish list" by looking at the pools and volumes etc

I am sure there is a better way of doing that.

Any pointers appreciated!