You have to write a VBScript using the CDONTS library (or equivalent).
What OS are you using? Is this for a hosted server or in-house?
Finally, use the stored proc to call
cscript.exe path_to_vbscript_that_sends_email arg1 arg2 arg3
(there are spaces following the path to pass input params, like the email address and name of the person)
If you [or it] can't find cscript, just search your hard drive and use the full path..
To capture the args in VBScript, there should be a collection named WScript.Args, also searchable.
It's not going to be an easy task if you have to learn VBScript from scratch! (but you have all you need to know, theoretically)