Computing.Net > Forums > Database > Access Query to Merge with Word Doc

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access Query to Merge with Word Doc

Reply to Message Icon

Name: daniel520
Date: February 6, 2007 at 14:40:56 Pacific
OS: Win2000
CPU/Ram: 2 GB
Product: Custom Build
Comment:

Hello All,

I work as a programmer for a direct mail company.

Here is my problem:
I am developing a Access (.mdb) database for a company that we just mailed tax forms for to there customers. The company is asking for the data back in a format that they can look up customers by account and check the information that we mailed to them for verification and corrections. Hence why I decided on access and developed some forms and queries to dumb it down and make it user friendly. Easy... Now the customer has asked if we could also make a report for them that looks like the tax form we mailed for them so they can query a persons account and print a new form for them to mail.

My first thought is a form in access that queries the desired record then merges the records to a MS Word document.

I know how to merge and query a database from Word itself using Mail Merge...Easy

I know how to query the desired records from access...Easy

What I cannot figure out is how if possible I can from access query the records for print and export the data directly into a preformated Word Document (Template).

Did that make sense...?

Normally we use High End software for our Design Merging. But this is for a client.
And I have to stick strictly to there format, hense why I won't even try to recreate the Tax Form in Access as a report.

And this all has to be very user friendly, thus a solution of just a word document that they could then Mail Merge from would be to hard it all needs to be automated.

Thank You All



Sponsored Link
Ads by Google

Response Number 1
Name: daniel520
Date: February 6, 2007 at 14:45:24 Pacific
Reply:

Follow up to my own post...

While Perl is what I use most, I do understand VBA pretty well. And assume this solution will be almost completly done in VBA. So don't hesitate to post some VB code examples.

Thanks Again.


0

Response Number 2
Name: seawatch
Date: February 6, 2007 at 17:00:47 Pacific
Reply:

I'm sure some one with more experience than I will answer you, but I believe you have to set up a table in Word that matches the fields in the Access database.

Larry

Sometimes I think I understand everything, then I regain consciousness


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Access Query to Merge with Word Doc

How to merg fields in MS Access www.computing.net/answers/dbase/how-to-merg-fields-in-ms-access/461.html

Access Query to Form Question www.computing.net/answers/dbase/access-query-to-form-question/50.html

Sql query to stop a service www.computing.net/answers/dbase/sql-query-to-stop-a-service/428.html