Export single record to MS Word template

[utzja1]

Hi, I have had great support in asking questions on this forum, so I am back with a new project. I am working in Access 2013.

I'll be performing a series of inspections at a number of intersections for a small community. The data being captured is consistent from site to site and lends itself to a database application, and what I would like to do is the following:

• Use forms to capture the data.
• Generate a report to preview the output for a single record. I may ultimately decide to set the report datasource to a query.
• Attach a macro to a button that exports fields from that record to a template based in MS Word.

The first two bullet items I can handle with my limited Access capability. The third is where I need help. Each file has to be individually reviewed and saved, and each file will ultimately contain an electronic signature. Based on this, I don't know that a Mail Merge is what I want.


All suggestions are welcome. Many thanks.

 

[Rx_]

For simple automation look into the Mail Merge. A table could be created with the information and results (the single record)

For better automation, consider the code to the reply I provided in another post.
If anything, the key words in the code should provide some insight to a slightly different solution.
http://www.access-programmers.co.uk/forums/showthread.php?t=254150&highlight=word

 

[utzja1]

Thanks for the reply; I will look into the code that you provided. I figured this question had to have been asked before on this forum.

Unless I'm failing to fully understand the Mail Merge output, I don't think it's the route I want to go. Each file has to be reviewed, signed and submitted individually.

Great TJ quote in your post, btw.