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?
-
-
http://www.members.sha w.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. -
Originally posted by MGrowneyARSI
Thanks a lot, I will give it a try immediately
MattComment
-
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.Comment
Comment