Using Macro to connect to ODBC and run SQL script

[Timelord]

I would like a Macro to run in Word that would then connect to an ODBC source, then an SQL script run to capture values from the database. Is this a pipe dream, or is it possible?

Thanks

[Timelord]

Sorry, I have more info. I want those values then to fill fields on the Word document.

[HansV]

That should be doable:
- Create an ADODB connection to the database.
- Open a recordset.
- Get data from the fields of the recordset and use them to populate fields in the Word document.

[Timelord]

The script that I want to run would include variables based upon fields captured on an html form. It would be something like:
select alphanum from jkl.running where primaryvalue = [variableprovided]

Then paste the alphanum into a Mail Merge field or some other way of telling the system where it belongs on the letter.

I cannot use a recordset as the values will be changing daily.

[HansV]

The idea would be to generate a SQL string dynamically in your VBA code, i.e. in runtime.
Then open a recordset on that dynamically generated SQL string.

[snb]

You can link a Word merge master document to any database.
No Macro needed.

[Charles Kenyon]

You can link a Word merge master document to any database.
No Macro needed.

I think Timeford wants this to run without user intervention at that point. Anything needed would be in the macro or the html form.

[robertocm]

I use this for invoices, with data from SQL Server (see the macro: "Consulta_Factura"):

invoice_template.docm

[snb]

You can link a Word merge master document to any database.
No Macro needed.

I think Timeford wants this to run without user intervention at that point. Anything needed would be in the macro or the html form.

Nothing simpler without user intervention than a macro:

Code: Select all

With documents.open(G:\OF\master.docx")
   .mailmerge.execute
   .close -1
 end with 
 activedocument.printout

[Timelord]

Thank you all. This is all good information.