My Access database has a Form (with a button on it) and a Report ('RptMaster'). When the button is clicked, I would like Access to Export the Report to an MS Word Document ('Word Catch').
Note: I would only like information related to the Last Record Series worked on to be exported to ‘Word Catch.’
I would like the Word document to automatically perform the following functions:
1. Open with the newly imported information
2. Delete any paragraphs that begins with 'Delete—'
3. Format the document so that all remaining paragraphs are shifted up—so that there are no huge gaps between each paragraph (I'd like the report to look orderly and organized).
For your reference, I've included a sample of the current Word document as it looks now—you can see how some paragraphs begin with 'Delete—' and you can also see how there are large gaps between some paragraphs.
Also, the Word Document is located at: C:\Users\Matt\Desktop\Worl
Thanks for all of your help.