Populate Word document with command button on Access form

[TinaR]

I'm using both Word and Access 2007. Is it possible to use a command button
on an Access form that when selected opens a Word template (new document)
and populates fields on the Word document from corresponding fields in the
database? I know I can do this with Word's Mail Merge feature but would
rather not use Mail Merge in this instance. Thanks in advance.

Tina

 

[Albert D. Kallal]

I'm using both Word and Access 2007. Is it possible to use a command
button
on an Access form that when selected opens a Word template (new document)
and populates fields on the Word document from corresponding fields in the
database? I know I can do this with Word's Mail Merge feature but would
rather not use Mail Merge in this instance. Thanks in advance.

Tina

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try....

 

[TinaR]

Thanks! I'll review and let you know how I do.

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try....