473,327 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Transfer Results to a Preset Word Doc

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
3 1572
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
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
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

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

Similar topics

0
by: Eric | last post by:
Hi, I am new to internet programming. I would now like to create a platform which allow two users behind different boardband router to exchange files. There are only two users in the system and...
13
by: Peter Amberg | last post by:
I would like to create a link on my page that opens the standard e-mail application when someone clicks it. It should have at least the subject preset, better if I could preset the body as well. I...
0
by: Vrushal | last post by:
Hii HOW TO: Transfer Data to an word Template by Using ASP.NET What i m trying to do is .. User will select the word Template (dot file) from the asp.net page, and when i ll click SAVE i want...
6
by: Shaun Wilde | last post by:
I am trying to handle a 404 errors and redirect them to the correct page based on criteria I was hoping to catch the error in the global error handler and forward via Server.Transfer to the...
5
by: Guadala Harry | last post by:
I've been reading up on Server.Transfer as well as doing some testing, and it appears to always raise the ThreadAbortException error. On one hand I've read a bunch of promotional-type material...
11
by: Alexander Bosch | last post by:
Hi, I'm having a problem similar to the one that's stated in this KB http://support.microsoft.com/default.aspx?scid=kb;en-us;839521 When I'm posting a page to itself with the bool value as true it...
1
by: ajdude | last post by:
All I need, is to have some preset words, and when the page loads, if the preset words that are in the code are on the page, and alert come like like "Word found" or if one of the preset words like...
4
by: micatcat | last post by:
Hello, I have a text field that gets populated when the user clicks on the submit button. How do I transfer this field onto a Word document? Please help me.
1
by: sycryc | last post by:
Here's my Q. I have a form in which users fill in text boxes and select checkboxes. After the form is completed, the user clicks the submit button which then transfers all to a word for editing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.