I have a Microsoft Access 97 database with 700 entries in it. I need to take each entry and put it into a formatted document. I have no freedom on the format of this document, I have to use exactly what they give me. it is a MS Word document.
Once the documents are done, I need to put each document into a separate folder (which already exists)
Example file structure:
I can make a mail merge move around the data into the shell document, but I then end up with a single 1400 page document, instead of 700 seperate documents. I cannot simply cut & paste the 2 pages at a time into new documents, because selecting the data only takes the data, not the formatting of the document.
Have you tried going to tools in the Word document clicking on Mailmerge then
1.Create - form letter - active window
2.Get data -open data source - use existing
Then go back to Word document and insert the "merge fields" in the proper place in the document and then print them to file.