Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link word document to acces query 2

Status
Not open for further replies.

Sjoker

Programmer
Aug 4, 2000
30
NL
I've got a template created in word and now I want to link each field in this template to a specific query in a access database.
How do I realsie this?
 
I am trying to do a similar thing, trying to populate a combo box with the data in a table in Access.

I have been looking for info and the best thing I have found is DDERequest (a word command), or a GetObject (another word command).

I found these to be very poor and couldn't get the DDERequest method to work.

If you find an easy way of doing this please let me know. If I find a way of doing it I will let you know.

Mark.
 
Dennie, create a mailmerge main document out of your template. Open the template directly. Hit Tools-Mailmerge to get the Mailmerge helper. Hit Create main document and tell it to use Active window. Hit Get data and go to your *.mdb file and use your query as the source (if you can't use the query--but I think you can--then do a make table from your query to get the data into a table). Agree that you want to Edit your main document. You'll be able then to Insert Merge field to get your data fields into the mailmerge main document. (Use the <<abc>> button to test that the fields are right.) After you've got all the codes in, save it again as a template. Then hit File-New, double-click your template and then do the merge.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top