By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Exporting current data in a form to word document

P: 9
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.
Feb 21 '14 #1
Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,287
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
Feb 21 '14 #2

P: 9
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.
Feb 21 '14 #3

zmbd
Expert Mod 5K+
P: 5,287
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?
Feb 21 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.