Form Letters mail merge problem

[Reimondo]

Hi there,

I'm trying to create a form letter in MS word which can be accessed via a hyperlink on the main form. ie. If i'm on client ID 1, and i click on the hyperlink, it will create a form letter will the name and address details automatically filled in.

But I'm having problems with the data source. It seems that if I try to set the data source of the mail merge document to be a query which contains references to a value in a form then it doesn't work and cannot detect that query.

In the query i wish to mail merge with, I have the statement "WHERE (((Client.ClientID)=[Forms]![Main]![Client ID]))" which would create a form letter corresponding to the current client record i am currently viewing. Are there any known problems with queries like these which contain references to form values?

If i try setting the data source to a normal table or another query which contains no references to a form, then it works perfectly fine. But I need the reference to the form in my query though.

I've tried the Tools > Office Links > Merge it with Microsoft Work method in access, and also the merge wizard in Microsoft Word, but both seem to have the same problems.

Can anyone help me with this problem or offer any other techniques of mail merging with form letters? I would prefer a solution which doesn't involve any VB as i'm not familar with VB.

Your help will be most appreciated,


Raymond

 

[dan9991]

You can try creating a form based on the querry showing everything you said then use the form in word. SEt the mail merge and should have no problems. I am coming to that stage as well. Can it find the database.