Hi Jeff,

I would choose a web-"application" to achieve your goals.

With VisualBasic .NET (or PHP etc.) you can query the customer for the information needed (via a HTML-form), build a query...

You have to configure an eMail-Account while you're logged on as the user under which SQL-Server-Agent normally runs (creating a "profile"). Then log off and choose this profile in Enterprise...