Access Archon #174 Introduction Many of my code samples write data from Access tables or queries to document properties in Word documents. For this technique to work, you have to add the appropriate doc properties to the Word template, which can be a time-consuming process. In this article I automate the process of creating […]
How to insert a field in a Word document that calculates dates. Q: George Forsythe writes: “I want to insert a field in a Word document that calculates Tomorrow’s date. It would be even better if I could make it Next Weekday’s date. There seems to be no intuitively obvious way to do this.” A: […]
Charles Hui writes: After reading your article “ACCESS Archon Column #44 – Merging to Word from Linked Access”, I have expanded my WORD template to include a table and have successfully created letters using custom doc property and table together. In our letters, the fixed Borrower Name and Address are printed at the top of […]
More on how to merge data from recordsets and queries to Word documents. Access Archon #168 Creating Queries on-the-fly for Filtering Data If you need to send letters to customers, and want the option of filtering by any country, not just the ones with the most customers, the frmMergeToWordDocProps form (shown in Figure D) […]
How to merge data from a recordset based on a query to Word documents. Access Archon #168 Introduction An AW reader wrote to me asking if the document properties merge code in my Code Sample #24could be modified to merge data to Word from a query, instead of selections in a listbox. While the […]