I have a database called CheckEntry; it is used to log basic information from checks that need to be distributed to individuals. It is required to be able to print out a list of all the checks received and logged for that day which it does magnificently.
Each check is also required to have a individual document attached to it with the information in the database to be signed and completed by the recipient to provide a receipt that the check was picked up.
Currently after entering all the checks into the database the user has to navigate to the linked word document which I then utilized the mailings feature of word to complete multiple individualized documents quickly.
I realized today that Access allows for attachments within the database and I have attached the document into the database so it is able to be opened from within the database.
I am looking for a way in which I would be able to create a button which opens the document and from Word prints all of the individualized documents by using the "Finish & Merge" -> Print Documents button located on the mailings tab in Word 2007.
If there is a way to do this all with a single button/macro that would be awesome since most of my users are extremely lacking in computer skills. I'm open to any suggestions at all.
The database currently has: