I have an application that needs to publish results in MS Word in a "Mail Merge" type activity. Insert fields in a template document which only outputs a selected recordset or single record. Do I use the Shell command for this, or is there a way to publish a SQL statement that would accomplish this. (This is easily performed in Access, is it similiar type commands?)
Database: MS Access 97
Application: VB 6.0
Details: Single form brings up a single record. Send that record to an already made word document with insert fields that need data from the VB form.