Opening a Word document to include merged data

[RitchieJHicks]

Hi,

Reports are not an option for us in this process - we require MS Word.

I want the user to be able to click a button or hyperlink from the main db
form which opens a Microsoft Word document (that contains the field from my
db). However, I would prefer it if the user did not have to search for the
record they have just created to merge the data (i.e. when the user clicks
the link to the word document, the data from the field they have just created
is automaticlly merged into the word doc).

Is this possible?

 

[Albert D. Kallal]

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 follwoing 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.