Merging Access data into a Word doc.

[JimRich]

Like many people I want a single button that will open a Word Mail Merge doc. What I would like is when the Word doc is opended it would have the fields already filled with the data and not have to run the Mail Merge function in Word.

My user will make a selection by Letter Name on an Access form. The form is based on a query that has selected the proper client. (The query is not the problem.) When she selects the Letter from about 25 preformated letters MS Word should run, open the proper letter and show the data not field names. Right now I can do all the above except that I get field names on the letter and have to run MailMerge, select a query from Access and all the other Mail Merge choices to get it to work. It should not be necessary for my user to have to do all that. Teaching them to do it may be harder than learning how to program it.

Thanks to anyone who can help. I hope I described the problem adequately.

JimRich

 

[Albano]

Hello,

This solution my help you. Try making a ODBC connection to the query, and making all the mail merge steps, then save the word document and wen you open it in acess the word doc, showld open with the connection to the query.

To see the data not the filed, wen making the mail merg, press the button abc (view merge data) on the mail merg tool bar an save the document.

I hope tis help you.

Good luck,

Albano