{"id":238,"date":"2021-11-02T20:05:57","date_gmt":"2021-11-02T20:05:57","guid":{"rendered":"https:\/\/ouritsource.com\/blog\/?p=238"},"modified":"2021-11-02T20:24:30","modified_gmt":"2021-11-02T20:24:30","slug":"example-of-vba-code-running-in-outlook-2016-to-connect-to-sql-express","status":"publish","type":"post","link":"https:\/\/ouritsource.com\/blog\/example-of-vba-code-running-in-outlook-2016-to-connect-to-sql-express\/","title":{"rendered":"Example of VBA code running in Outlook 2016 to connect to SQL Express"},"content":{"rendered":"\n

This VBA example was configured to run in Outlook 2016. It connects to a local SQL Express Database and insert a record. In order for the VBA to connect to the SQL server, a reference to ADO was required in Visual Basic For Application. To establish that reference, in Outlook, had to click on tab DEVELOPER\/VISUAL BASIC\/TOOLS\/REFERENCE\/ and placed a check on checkbox Microsoft ActiveX Data Object 2.0 Library. Go to https:\/\/www.ouritsource.com\/upl\/1456990546-ado.png to see image.<\/p>\n\n\n\n

\n