Working with Word Document Properties, Part 1
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 […]
Placing calculated dates in a Word document
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: […]
The Office Envelope Object and Office 2000
Using the Office Envelope Object in Office 2000 – what works and what doesn’t. Some readers have asked whether the Office Envelope Object (featured in Access Archon #122) can be used in Office 2000. Well, sort of. While writing the article, I tested the two procedures in Office 2000 and found that the Word procedure […]
Reader response to “Merging to Word from Linked Access” article
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 […]
Merging Access Data to Word
How to successfully merge data from Access to Word. Q: Bruce Michael writes: “I have been attempting to do a merge in Word 2003 using an Access 2003 query. When I look in the query, the data is correct, but when I actually merge using the data, for one column in the database, the values […]
Merging Data from Queries and Recordsets to Word, Part 2
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) […]
Working with Word Document Properties, Part 2
Access Archon #174 The code that does the work of listing, clearing and copying doc properties is listed below. VBA Code Private Sub cmdCopy_Click() On Error GoTo ErrorHandler Dim cbo As Access.ComboBox Dim intType As Integer Set cbo = Me![cboSelectTableOrQuery] strTemplate = Nz(Me![txtTemplate].Value) strRecordSource = Nz(cbo.Column(0)) […]
Merging data from Queries and Recordsets to Word, Part 1
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 […]
What is the ‘Custom XML’ feature in Word?
About the feature that Microsoft has to remove from Office 2007. Just what is the ‘Custom XML’ feature that Microsoft has to remove from Office 2007? The Office 2007 document formats (docx xlsx pptx etc.) are stored in XML format which looks like the HTML used in web pages. For example here’s a bit of […]
The mystery Word patch
Microsoft says it’s been working on the Word 2007 patent patch for months, so why does it look like a rush job? As we’ve previously reported, Microsoft lost another round of the ‘Custom XML’ patent case and must stop selling, in the USA, Office 2007 with the offending code after 11 January 2010. According to […]
Word case goes against Microsoft
Microsoft loses another round in a Word patent case, an Office update is coming in the new year. A US court judgment seems to have forced Microsoft to release an update to Office 2007 in the new year. The US Federal Circuit Court of Appeals has upheld the judgment that Microsoft breached a patent in […]
Sending a Christmas email
It’s too late for Christmas cards but not too late for a simple Xmas Email. We’re the first to admit that sending a Christmas email isn’t the most traditional method but it can be done with good cheer and grace. Here’s just one example from a friend and some tips from the writer and designer […]
Can Word 2003 macros be copied & pasted into Word 2007?
VBA macros should migrate from Word 2003 to 2007 but don’t bet on it. Yes, VBA macros from Word 2003 should work in Word 2007. We always say ‘should’ because there are inevitably changes in VBA behaviors between versions of Office and “Murphy’s Law” says that one of these ‘minor’ differences will affect you. Any […]
Converting a PDF to Word
How to convert a PDF to a Word document and why it’s so hard. ” One of the things that drives me crazy is that it’s easy to convert documents from Microsoft Word 2007 to PDF (for commercial printing) but very hard to convert PDF back to Word without screwing up all the formatting. Do […]
Cleaning docs without Word
Doc Scrubber lets you remove hidden Word info without Word itself. Some years ago, Microsoft ‘discovered’ the problem of ‘meta-data’, their term for the additional information in a Word document that you might not want to share with others. The most common meta-data problem is revisions – you might not want other people to see […]
Access Archon – Working with Word
A new ebook on using Microsoft Access to make great Word documents. Office Watch and Helen Feddema are delighted to announce the publication of a new Office Watch ebook especially for Microsoft Access users. Access Archon – Working with Word by Helen Feddema, editor of Access Watch. Like other Office Watch ebooks – […]
