Calling a Stored Procedure inside mysql

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
Back
Top