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

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.

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