|
What I do is
I generate a query that contains all the info I might need e.g. Name, Address Line(s), Reference numbers etc and have this exported to a comma delimited (CSV) file
e.g. c:\temp.txt
Word can pick this up as a data source, and use it to create one or more pages (one record would create just one page)
As soon as the .dot file gets loaded the Macro forces it to perform said mail merge
I will see if I can paste up the code (it's pretty simple)
OR
I recently needed to jump around a Word file, modding every third page or so. For this I used DAO. You might want to use the same method to jump to the most recently created record and pull some data that way.
OR
For a quick fix, maybe think about using the Record Selector on the Access form to just dump data to the clipboard and get the user to paste it into a Word template
HTH
Rob.
|