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

Transfer Results to a Preset Word Doc

P: 73
I run a query that gives me about 50 rows of data every month and then i have been manually inputting this data into a word doc. The only fields I am having to update is State, Branch, and Account #. Then this Word Document (has a the legal jargon it needs) is faxed to those Branches to remediate issues. I have been trying to find an easier way of doing this and haven't found to much to work. Is there an easier way of doing this that is automatically prefills the data source to the word doc?
May 15 '08 #1
Share this Question
Share on Google+
3 Replies


MGrowneyARSI
P: 90
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

use the word merge code from here you can create templates with headers pictures whatever then just run the merge and dump whatever data you want into the word doc. just on peace of advice though if I remember correctly the query you use can not have any criteria in it or multiple tables I believe I worked around this by building a query with the criteria and table needed and then building an new on based off of the first.

well it's a simple enough merge process and should do exactly what you need.
May 15 '08 #2

P: 73
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

use the word merge code from here you can create templates with headers pictures whatever then just run the merge and dump whatever data you want into the word doc. just on peace of advice though if I remember correctly the query you use can not have any criteria in it or multiple tables I believe I worked around this by building a query with the criteria and table needed and then building an new on based off of the first.

well it's a simple enough merge process and should do exactly what you need.


Thanks a lot, I will give it a try immediately

Matt
May 15 '08 #3

MGrowneyARSI
P: 90
Let me know if you have any issues or contact Albert D. Kallal I've E-mailed him a couple of times about changes i made the code. He's a great guy and a brilliant programmer. you shouldn't have to much trouble setting it up though the trickiest part like i said is the query.
May 15 '08 #4

Post your reply

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