Alright -



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:

tblCheckData
frmCheckEntry
rptCheckList

- Dan

As far as I know there is not a simple way.

What would be really simple is to use a Access report. Is there some reason you are not using a Access report?

I use a report as well for an overall list of each record; the word document is used because I need to complete individualized documents for each record and word was the easiest method I was aware of for creating a document for each record. I was unaware you could create individualized reports for each record.

If you set up a grouping, usually on the primary key or some unique identifier, and set it to foruce a new page before each group item. This will produce a separate page(s) for each record.

That's a great idea, How do I force each record to have their own page? Thus creating the unique reports I need for each record. I added a primary key ID for the records now and can successfully group by the ID but I can't find how to force each record to have its unique page.

Thanks for your help means a lot

Look at the properties for the group header section. I normally right-click > properties on the bar across the top part of the group hearder.