Open MS Word and Insert Data

[gomez65]

I am helping a friend with an Access DB and I am having trouble with this:
I have 2 drop down boxes in a form. In one, the user will select the customer name from a table, and the other the specific MS Word document to be opened.
What I am trying to accomplish is to open the Word document and once is opened, it automaticly inserts the customer name, address and other information from the respective table.
Please help!
Thanks

[PEB]

Hi
U can do it by:

1. When you create the documents in MS Word, you have to use the Tools/Letters and mailings/ Mail Merge. This 'll create a document type that will get the information from your MS Access Query with the information about your customers

2. In Access you create a query that contains the info about your customer that is choosen from the list

3. U use the shell(Path, type of opening) to start MS Word and the specified Document

4. In word u click on Merge the document and it's ready!

[gomez65]

Hi
U can do it by:

1. When you create the documents in MS Word, you have to use the Tools/Letters and mailings/ Mail Merge. This 'll create a document type that will get the information from your MS Access Query with the information about your customers

2. In Access you create a query that contains the info about your customer that is choosen from the list

3. U use the shell(Path, type of opening) to start MS Word and the specified Document

4. In word u click on Merge the document and it's ready!

Thanks for the answer, but wouldn't this create a mail merge with all the clients in the query? I just want one particular client on the document I am going to print.
Jorge

[PEB]

Just this will create a merge with all info in the query! So to have the specified client you can use the follow code for creating an appropriate query:

Set mydb = CurrentDb()
Set Myquery = mydb.CreateQueryDef(names, SQLS)

SQLS is your query SQL where you specify the customer ID that you would like to appear!

Before Save the new SQL you should delete the ancient query!

So you have to insert those statements in On click event in the lists!