I’m happy to say that I’ve made some major improvements to the code using many of your suggestions.

Improvements:

• A more efficient (and shorter) procedure that handles errors.
• The procedure is commented better and should give you a MUCH better understanding of what is going on.
• An improved method of “waiting” until the subscription completes before continuing.
• The ability to handle multiple (almost unlimited) parameters.
• *BIG* The ability to NAME your subscriptions and refer to them by name. (As it would get difficult to manage by schedule IDs)
• More settings available on the subscription, like “include report/link, render format, etc…”

If you are interested, reply and I’ll send the updated procedures and instructions. There is a replacement for the main procedure, one to gather and format the parameters and a table to hold them. Once in place, it’s quite easy to use.