Executing SQL in outlook VBA

[Jawad Ali]

Hi,

I wan't to execute sql statements on the SQL Server in local intranet using outlook VBA Code.

Same in VB is done using ADODB Object but how to go about in VBA??

[BlackMustard]

Hi,

I wan't to execute sql statements on the SQL Server in local intranet using outlook VBA Code.

Same in VB is done using ADODB Object but how to go about in VBA??

You will have to import a reference library called "Microsoft ActiveX Data Objects 2.x Library", and then you can do as in regular vb (define connection and execute with sql parameter)