How to insert a database field into an MS WORD document and print document from an application

I have to print a questionnaire that is in MS WORD format to send to many establishments. The establishment's name and address are in a database and are indexed by a unique id field. I want to develop a procedure that will insert the unique id field then print the questionnaire for each establishment that is in my database.

Can this be done using an MS-WORD macro? I have developed quite a few database applications in VB6 but has never done anything involving the MS Office suite, so can someone please give me an overview of how this is achieved or point me to some resource that explains it. Thanks.

If you don't do mail merge which, by the way, is the best option, then I would investigate setting up a document that contains the letter structure you want but where the variable fields like name and address are entered as Bookmarks. Then you can write a VB app that queries the database and loops through the recordset and replaces each bookmark with the correct information. You would need to refernce the MS Word application in your VB program and then create a new Word object. Ther are plenty of examples of using bookmarks for automating Word to do mail merge type functions.

I am not sure that mail merge is what I want since the intention is that the establishment should remain anonymous. The questionnaire will be hand delivered. No name nor address information should be printed on the questionnaire, only the ID field. The delivered will know where to deliver the questionnaire because that person will have access to the database.

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…

If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…

Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…