You would call it the same way from any application that can run VBScript;
there would be no difference in Outlook. Your question is essentially ADO
related. Stored procedures are typically run this way with vbscript:

Dim conThis
Set conThis = CreateObject("ADODB.Connection")

conThis.Open "myconnectionstring"
conThis.Execute "MyStoredProcedureName"


--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Computer Newbie" wrote:

Hi, I am assisting someone trying to look up information for the following
question.
Please keep in mind that he is computer tech savvy and I am not. If this
question does not apply to you could you please direct me to the department
that would best handle this question.

How do I call a stored procedure inside my sql with a vba script inside
Microsoft outlook?

Thank you for taking the time.