Exporting current data in a form to word document

[rajendran r]

I am having a form and I wish to send the current data to a word merger fields. Is it possible.
Now I am raising a query by keeping a field in the form as criteria and converting the current data into a table via "make table query" and then I used to merge the data with the word document.

Any guidance in this regard. I am not much familiar with the access code.

[zmbd]

rajendran r

You're a little unclear here; however, the first thing I would try would be from within Word, using the built in mail merge automation to connect to the database.

You have not indicated which version of Access/Office so I will go on the basis that you are using ACC2007/2010 in which case following the instructions in this link should acheive your goals, if not, L.M.K.

Use a table or query as a mail-merge data source

I should also mention that there is from within Access2007/2010 in the External Data ribbon in the export group the Word Merge feature. This will allow you to merge a query to either a new document or an exsisting document. This may be a better fit for what you are attempting to accomplish

[rajendran r]

Thanks zmbd for your guidance.
I am using Office 2003. I want to merge that particular data which has been populated in the form and get the merged word document by clicking a command hyperlinked with the word document
thanks in advance.

[zmbd]

First read thru and understand the followng:
Word 2003 Mail Merge stops responding with "Word was unable to open the data source" error message when you use an Access parameter query in Access 2003

As for your form:
Are the controls bound or unbound?