link or export to word document

[neenmarie]

I have large word documents (contracts) that I'd like to complete using
information entered and stored in an Access database. I'd like to fill in a
form and/or retrieve info in Access and then open/link or export to the Word
document and have all the data 'fill-in' the Word doc. Can you get me
started in the right direction please?

 

[S Panja]

Use Tools | Office Links | Merge it with MS Word.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[John Nurick]

The general idea is to create a Word template (.dot file) with bookmarks
(or maybe formfields) at each point where something needs to be filled
in. Then you write Access VBA code that launches Word, creates a new
document from the template, pokes the data into the fields, and saves
it.


http://word.mvps.org is an excellent source of information about making
Word do what you want. This page
http://word.mvps.org/FAQs/OfficeInterdev.htm refers specifically to
working across Office applications.

If you need to include data from Access in tabular form, check out
Word's { DATABASE } field.

 

[neenmarie]

Thank you for the response....I'll work on it

Use Tools | Office Links | Merge it with MS Word.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[neenmarie]

Thank you for the direction. I'll try

The general idea is to create a Word template (.dot file) with bookmarks
(or maybe formfields) at each point where something needs to be filled
in. Then you write Access VBA code that launches Word, creates a new
document from the template, pokes the data into the fields, and saves
it.


http://word.mvps.org is an excellent source of information about making
Word do what you want. This page
http://word.mvps.org/FAQs/OfficeInterdev.htm refers specifically to
working across Office applications.

If you need to include data from Access in tabular form, check out
Word's { DATABASE } field.

 

[neenmarie]

I went to http://word.mvps.org/FAQs/OfficeInterdev.htm as you suggeted and
downloaded a zipped file with a db and word document. It was written in
Access 97 so had to be converted (of course didn't convert perfectly)

I'm getting a couple of errors when trying to run the sample. The following
code is
is giving the error:

runtime error '5':
Invalid procedure call or argument
at (AppActive "Microsft Wor", 1
====================
Public Sub AllFinished()
MsgBox "Done!"
AppActivate "Microsoft Word", 1
Set objWord = Nothing
End Sub
====================
Any suggestions?

 

[John Nurick]

The best place to get help on stuff from the Word MVPs site is in the
Word Programming discussion group (microsoft.public.word.vba.general).

 

[neenmarie]

Thank you very much.
I'll do that

The best place to get help on stuff from the Word MVPs site is in the
Word Programming discussion group (microsoft.public.word.vba.general).