By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

Executing SQL in outlook VBA

P: 2
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??
Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: 88
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)
Sep 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.