|
|
|
Monday 14th, July 2008 Added a handful of photographs to the 2008 gallery. Saturday 12th, July 2008 Word forum users increasingly complain that when opening Word documents they have received by e-mail, they are presented with a converter dialog box filled with garbage. This new page provides one explanation for this problem and the means of preventing it. Following on from the problems encountered on Wednesday, Doug and I have been trying to discover the cause of the error that affects the use of the macro in Word 2007 without 100% success, but we have made further updates to the macro to create a template for use in conjunction with the Individual Merge Letters add-in that seems to work without further problem. Please note that the problems leading to the changes only affect Word 2007 merge documents. For merges in Word 2003 and earlier, version 28 of the add-in contains exactly the same code as the current version. Wednesday 9th, July 2008 User feedback has pointed out that the code to create a merge template, that is an additional function of the Individual Merge Letters add-in, does not work in Word 2007. The problem may be attributable to a security update, as it certainly worked when originally created. I will investigate further and attempt to establish a workaround. In the meantime I have disabled the function for Word 2007 and updated the add-in available for download. If you already have version 28 of the add-in and are using Word 2007, simply ignore the function, or replace the add-in with temporary version 29. 12.30pm and I have fixed the problem. It appears to only affect merge documents in Word 2007 "docx" format. Changing the function to create working documents in 97-2003 compatibility mode will work, and for version 30 now available, this is what I have done. If this becomes a problem with documents that include Word 2007 features, I may have to further re-appraise the issue. Saturday 28th, June 2008 Added a new page which demonstrates how to extract the content or attachments of an e-mail message to a Word document. Monday 16th, June 2008 Added several pictures to the 2008 gallery. Wednesday 11th, June 2008 Another issue raised in the Word forums concerned the extraction of data from Word forms for use in a spreadsheet. A new page - Extract Data From Forms - demonstrates one approach to the problem. Saturday 7th, June 2008 Inspired by my answer to a problem posed in the Word forums I have added a page containing macros that enable autotext entries to be maintained in a Word table. Wednesday 4th, June 2008 Added a few photographs of the delightful Kelefos Bridge. Wednesday 28th, May 2008 Some photographs from the Cyprus mountains. Saturday 24th, May 2008 Modified the instructions with relation to using gmail as an e-mail washer. Friday 2nd, May 2008 Following user feedback, the original macro code to select printer trays on the 'print to a specific printer' page was ignored by Word 2007 and frequently crashed Word 2003. I have therefore altered the tray selection from 'by name' to 'by tray ID' and have added a method of identifying the tray ID numbers. Thursday 1st, May 2008 Updates to 'macropod's' datecalc and word field maths downloadable files. Friday 25th, April 2008 Following user feedback, added an extra illustration to the page relating to the recovery of edited Outlook attachments. Added a few more photos of the Kato Paphos re-development. Sunday 20th, April 2008 Yet more photos added to the 2008 gallery Sunday 13th, April 2008 Updated the macro code to extract data from similar documents, to incorporate an improved folder selection routine and to simplify the data entry into the storage document. Saturday 12th, April 2008 Yet more photos of the Kato Paphos redevelopment area. Thursday 3rd, April 2008 Two more photos added to the 2008 gallery. Wednesday 2nd, April 2008 Added an extra example to the formatting switches page, to clarify the formatting of telephone numbers. Monday 31st, March 2008 'Macropod's' excellent datecalc document has been updated to demonstrate the calculation of a date sequence/series on page 11. The revised document Version 2_70 is now available for download. Tuesday 25th, March 2008 Added a few more photographs. (Roman) Easter Monday 24th, March 2008 Work continues relentlessly on the Paphos re-development as shown in a couple of new photographs. Thursday 20th, March 2008 Added a page 'Associate Printer' which features a Word add-in to associate the printer name required for a document with that document. Tuesday 18th, March 2008 In conjunction with fellow Word MVP Doug Robbins who wrote the original merge splitter add-in, I have added an updated version of the add-in which overcomes the problems associated with merge documents that use templates other than the normal template. The web page has been updated to encompass the changes in the add-in. Saturday 15th, March 2008 Added a few more photographs of the Kato Paphos redevelopment. Tuesday 4th, March 2008 Updated the boiler.dot documentation, both supplied with the add-in and separately as a PDF download. Fixed a minor bug in the Word 2002 to Word 2007 version of the add-in. Monday 3rd, March 2008 Modified the macro code to backup documents to a flash drive and added an alternative simpler version of the code. Sunday 2nd, March 2008 Added a couple more pictures to the 2008 Gallery. Wednesday 27th, February 2008
Having just received my excess charges bill for
web traffic for the month, I had to go for a lie down
Monday 25th, February 2008 A few more photos of the Kato Paphos redevelopment. Saturday 23rd, February 2008 A few more photographs added to the 2008 gallery. Updated the Batch Replace macro code to improve the file selection dialog and to include mods. suggested by Greg Maxey to ensure that text in shapes in the header/footer is addressed. Saturday 9th, February 2008 An overnight message in the Word programming forum prompted me to resurrect an idea for establishing whether a printer was available before choosing that printer and printing to it. The macro requires code from Astrid Zeelenberg available at http://word.mvps.org/FAQs/MacrosVBA/AvailablePrinters.htm. Tuesday 5th, February 2008 Photographs from the completed Chlorakas section of the new coastal path that will eventually run from Paphos Airport to the coastal village of St. Georges. Sunday 3rd, February 2008 A few more photos of the Kato Paphos re-development. Friday 1st, February 2008
I have been using
Diskeeper 2008 for a
couple of months now to keep my hard drives free from fragmentation. This is an
excellent product that does exactly what it says on the tin. How boring is that?
Sunday 27th, January 2008 Pedestrians were allowed access to the Kato Paphos redevelopment site for the first time since work started, so I have taken the opportunity to add a raft of photos. Friday 25th, January 2008 Minor change to the page about inserting PDF files into Word as graphics. Thursday 24th, January 2008 Minor changes to the formfield validation macro to simplify the adding of the macros to the fields. A few more photographs for the 2008 Gallery. Saturday 19th, January 2008 A few extra photos of the Kato Paphos redevelopment added to the 2008 Gallery. Friday 18th, January 2008 Prompted by user feedback, I have added an alternative method of extracting images from Word, using PowerPoint as a vehicle to save the image. Saturday 5th, January 2008 The first new photograph of 2008 prompted the addition of a new photo gallery. Thursday 3rd, January 2008 The first edits of 2008 are to the envelope/label printing macros which enable the use of different printers when printing envelopes and labels, with additional code to cater for Word 2007. Monday 31st, December 2007 Finishing the year with a new page to help those having problems opening Word 2007 docx format documents in earlier Word versions. Saturday 29th, December 2007 Probably the last photographs of 2007 added to the 2006/7 gallery. Friday 28th, December 2007 The updated versions of the mail merge PDF documents have been uploaded to the downloads page. I have also changed the titles of the web pages they duplicate (though not the URLs as this would impact on the search engines) to reflect that the pages concern more than simply merging to labels. Labels were used as an example because they involve the most complexity. Thursday 27th, December 2007 A few more photographs for the 2006/7 gallery. Following on from yesterday's update to the Word 2007 merge page, it appears that the same method can, with one small proviso, be used from Word 2003, so I have added a note of explanation to the Word 2002/3 merge page. I will update the PDF versions in due course. Wednesday 26th, December 2007 Further to the addition to the mail merge pages on the 16th December, the same method could be used with Word 2007 to make the contents of the Categories field available to an Outlook merge from Word, by using the same macro code to copy the contents of the Categories field to one of the unused Outlook user fields. Wednesday 19th, December 2007 Some users of older versions of Word have reported that the boiler.dot add-in crashes with an error. This is because the folder selection routine used only works with recent Word versions (tested with Word 2003 and 2007). I have therefore posted a version in the same zip file that has a folder selection routine which is less elegant, but which does work. If you have problems, use the alternative version. Sunday 16th, December 2007 Users of mail merge have frequently bemoaned the fact that Outlook contacts does not have a field that produces the contacts' forename initial, which is frequently useful when addressing envelopes etc. It is possible, but not very convenient to use one of the four User fields to store the initial. I have therefore added an Outlook macro to both the Word 2002/3 and 2007 mail merge pages which writes the derives the initial from the FirstName fields and writes it to the User4 fields of the complete contacts list. Add the macro to a button on the Outlook toolbar and it is a simple matter to update the fields when new records are added. It takes but a few seconds to run on a list of several hundred records. Monday 10th, December 2007 It became clear today that users attempting to apply Microsoft's downloadable templates to the process of mailmerge are confused by the text already present in those templates. I have therefore added a section to the mail merge to labels with Word 2002/3 and 2007 pages hopefully clarifying the issue. Friday 7th, December 2007 A few more progress pictures of the Kato Paphos re-development. Wednesday 5th, December 2007 Updated some images on the macrobutton tutorial. Monday 27th, November 2007 I took a few more photos of the Kato Paphos developments yesterday and added two of them to the gallery. One of our remaining two cats has been very sick, but with the assistance of the vet we managed to pull him round. He has been taking full advantage of his new lease of life. Wednesday 26th, November 2007 Work has begun on the long awaited redevelopment of the Kato Paphos shoreline causing massive disruption, which will continue for at least three months. If you plan to visit Paphos before Easter 2008, the photos show something of what you may expect to find. I will add to them as work progresses. Sunday 25th, November 2007 Testing Friday's version of Doug's split merge add-in revealed an obscure bug that had been present from the start and which may have been the cause of some of the odd failures that one or two users have reported. Following a merge to separate files, if you then merged to printer without restarting Word the merge completed with an error that stopped the add-in from working. This has now been fixed and version 25 of the add-in is now available for download. Saturday 24th, November 2007 User feedback has pointed out that the possibility for changing the default location that Word looks for its mail merge data sources was not quite as rigid as I had suggested in the mail merge pages for Word 2002/3 and 2007. This has now been corrected. Friday 23rd, November 2007 Doug has done some more work on the problematic area of the mail merge splitter add-in MMtoDocs.zip, Version 24 now available to download has some neater code, but essentially does the same as version 23. This is not a 'must have' upgrade if you already picked up version 23 since yesterday morning. Thursday 22nd, November 2007 User feedback has reported an issue with version 22 of Doug Robbins' mail merge splitter add-in, previously contained in MMtoDocs.zip, where the field chosen for the filename has more than one entry with the same data, which caused the add-in to crash. A bug had crept in when I modified the data to make the add-in compatible with Word 2007 that was missed during tests. This problem was not present in version 20 so if you are running that one with versions of Word before 2007, then there is no need to do anything. Doug and I have been working on a fix, the results of which are now available to download. For 2007 users and new users, version 23 should fix the problem. If you have any difficulties with this one, please report back. Thursday 15th, November 2007 Changed the folder selection dialog in the boiler.dot add-in to clarify the dialog function. Thursday 8th, November 2007 With assistance from friend and fellow MVP Greg Maxey, the boiler.dot add-in now provides for multiple files to be selected at once and for selected files to be re-ordered before adding them to the document. Thursday 4th, October 2007 Made a few small changes to the graphics on the formatting Word fields with switches page in relation to ZIP codes. Monday 2nd, October 2007
I have been re-awarded MVP status for another
year, for my contributions to the Microsoft Word community, and PayPal has
finally (and seemingly grudgingly) recognized that Cyprus is an EU member state
and has accorded its residents some of the privileges of other member states, in
that we now have the limited ability to receive payments. So I have re-added a
link to the header of each page, to enable those desperate to make a contribution to be able to
do so
Sunday 23rd, September 2007 Macropod has done some minor editing and added a bit on displaying graphics at print time to his Date Calc document. His Word Field Maths document has also been revised, with the addition of items on 'Calculations In Word Forms' and 'Identifying Cell Addresses'. The http://www.wopr.com web site is now back on line and the documents are also available from there. Also added a few photographs to the 2006/7 gallery. Saturday 22nd, September 2007 Following a number of newsgroup reports from Word 2007 users, about the issue of disappearing page headers, which hitherto was believed only to affect Word 2003, I have updated the relevant page to cover Word 2007 also. Monday 17th, September 2007
The house sale seems to be well on its way to
completion, so I have taken a chance and removed the advertisement. It can
easily be resurrected from my backup if it all goes wrong at the final hurdle
Saturday 15th, September 2007 Added a page to demonstrate the insertion of a date selected using a pop-up calendar control to a form or document. The calendar control may not be available in some versions of Office so the ActiveX controls to make this work have been added to the downloads page. Thursday 13th, September 2007 We have accepted an offer on our house for sale so I have added a 'Sold subject to contract' note to the page. I have also added a note to the Word 2007 toolbars page concerning unusual behaviour when used with Outlook. Monday 3rd, September 2007 On the 24th, August, I changed the feedback link to a feedback form. I didn't like the way that this worked and so I have changed it back to link to my support e-mail address, using your own e-mail software, until I can get around to improving the form. Sunday 2nd, September 2007 While looking at the boiler.dot add-in in response to a user query, I decided to add a check box to the user form to eliminate an untidy input box to allow the user to choose whether to insert the documents on separate pages, and took the opportunity to update the readme file to include Word 2007 related illustrations.. Monday 27th, August 2007 Updated Doug Robbins' add-in to merge to separate documents with code to enable it to work with both Word 2003 & 2007. Sunday 26th, August 2007
Pasting macro code from Word's vba editor into
FrontPage loses all the layout and colours. I spent a happy few hours
Saturday 25th, August 2007 Attended to some 'housekeeping' - fixed some broken links and tidied up a couple of macros. Nothing worth directing attention to at this juncture. Note that as of today www.wopr.com (see previous entry) is still down Credit goes to fellow MVP Herb Tyson for discovering the ability to scan directly into Word 2007 - a function that appeared to have been left out of the application. Friday 24th, August 2007 Following the crash of www.wopr.com, from which could be downloaded fellow MVP 'Macropod's' impressive works on field date calculations and mathematics, I have offered to host the two documents on this site. They are now available from the downloads page. I have also replaced the feedback link on my home page with a form. This is to cut down abuse by spammers. I will not respond to any unsolicited mail to my web site address that does not use this form. The form does not accept attachments. Saturday 18th, August 2007 Fellow MVP Beth Melton has pointed out that I have misunderstood the process whereby Word 2007 adds spacing on labels created using mail merge. This doesn't affect the procedure illustrated on my web page on mail merge with Word 2007, but I felt it worth putting the record straight with an additional note of explanation. Monday 13th, August 2007 It has been pointed out to me that on yesterday's new page, I suggested that it was necessary for your mail server to be able to re-direct mail to GMail. This is not strictly true. GMail will in fact collect your mail from another five accounts! I have added the extra steps to make this happen. It was also pointed out that I had missed a setup step in the configuring Outlook instructions. This was because a similar dialog is used for both Outlook and Outlook Express and I missed its duplication. Enough of the excuses. That too is now fixed. Sunday 12th, August 2007 If you frequent the web and especially newsgroup forums and use your real e-mail address in a web page or forum, it will only be a matter of time before you start to receive loads of e-mail inviting you to enlarge your penis, surgically enhance your breasts, buy drugs that you didn't know you needed and a raft of other nonsense. This takes up your time and bandwidth, but all is not lost. Thanks to a suggestion by fellow MVP Juan T. Llibre you can overcome the problem by using Google Gmail either as a your main POP e-mail account or as a means of washing the e-mail sent to your existing account. In order to do this, the only requirement is that your existing e-mail account must offer the facility to automatically re-direct mail to another address. This new page explains how to set it up. Monday 6th, August 2007 Made some changes to the macro code for clearing the recent files list to provide a single macro that works with both Word 2007 and earlier versions. Monday 30th, July 2007 Added a note to the lost Outlook attachments page to cover the new behaviour of Office 2007. Sunday 29th, July 2007 Added a few notes relating to Office 2007, to the Mail Merge from Outlook page, and I have moved a couple of cat pictures to the appropriate gallery from the 2007 gallery and updated the story in pictures of our feral cat family. Thursday 26th, July 2007 Some more drought pictures added to the photo gallery Sunday 22nd, July 2007 Simplified the presentation of the calculation to present cash amounts in words. Friday 20th, July 2007 When updating the web pages at the start of the month, to accommodate the changes to accommodate Word 2007, I appear to have overlooked the mail merge graphics page. That omission has now been rectified. Also added a couple more photos. Sunday 15th, July 2007 In response to user feedback I have made a few small modifications to the Idiots Guide to Macros to attempt to make it even easier for the beginner to understand. Saturday 14th, July 2007 Added a few more pictures from Thursday's trip to the mountains. Tuesday 10th, July 2007 Added an experimental local temperature indicator to the home page and house sale page. Added a few pictures to the 2007 Gallery. Wednesday 4th, July 2007 Added a new page which demonstrates how to install the Office 2003 proofing tools for use with Office 2007 (an Office 2003 installation disc is required). Monday 2nd, July 2007 Completed the addition of Word 2007 updates where applicable: Alternative Return Addresses, Replace Using Wildcards, Word Text to Speech, and What To Do When Word Crashes. The PDF versions of the Mail Merge, Switches and Convert Labels To A Data File have all been revised. If you spot any oddities or errors, please let me know. Sunday 1st, July 2007 Added links to Fellow MVP Patrick Schmid's Word 2007 related web site and blog, where you will find his excellent ribbon customizer. Updated Autotext Replace, Convert Labels to Mail Merge, Individual Merge Letters, Select File from Dropdown Form Field and Graphics On Labels to add Word 2007 dialogs. Saturday 30th, June 2007 Added a new page which shows how to run Word 2003 (earlier versions should work too) alongside the new Word 2007, without conflict; and how to retain the toolbar buttons from 2003 for use in Word 2007. Updated a number of pages to display Word 2007 dialogs, where relevant, as part of an ongoing process to include Word 2007 instructions wherever possible. Friday 29th, June 2007 Modified the envelope editing page to include setting up a document to use window envelopes (albeit this has little to do with changing envelope layouts). Wednesday 27th, June 2007 Modified the envelope editing page and the macrobutton page to take account of the changes for Word 2007, and added a few more pictures to the 2006/7 gallery. Monday 25th, June 2007 Modified the two macros for saving numbered versions of documents for improved compatibility with Word 2007 whilst maintaining compatibility with earlier versions. Updated the envelope samples for improved compatibility with Word 2007 and added error trapping. Added error trapping to the macros to insert entries from Outlook on the Macrobutton page. Sunday 24th, June 2007 Added a note to the mail merge labels with Word 2007 page concerning the default use of paragraph styles. and updated some of the images. Saturday 23rd, June 2007 Added a few photographs from Thursday's trip to the mountains. Wednesday 20th, June 2007 The temperatures outside are soaring so I have used the extra time indoors to add another page on the subject of mail merge, this time for Word 2007. This is essentially the same information as posted in the popular Mail Merge to Labels with Office XP & 2003 page, but showing the dialogs for the new Word version. Tuesday 19th, June 2007 Created a new page to demonstrate how to Create Outlook Entries From Word Added a note to the Individual Merge Letters page with reference to the use of templates with the split letters. Saturday 16th, June 2007 Added illustration to the Individual Merge Letters page showing the dialog for Acrobat 8 Tuesday 12th, June 2007 Added a note to the mail merge labels page to explain how to use a label template not listed in the envelopes and labels dialog. Added a note to the custom labels page to take account of the differences presented by Word 2007. Also added a couple more photos to the 2006/7 Gallery Sunday 10th, June 2007 Updated the 'Idiot's Guide to Macros' to display also the dialogs for Word 2007. Monday 4th, June 2007 Minor modifications added to the macro to duplicate graphics across all the cells of a table to restore the original display of field codes. Friday 1st, June 2007 Added a new page to demonstrate a method of extracting data from a series of similar documents. Friday 11th, May 2007 It appears that recent security updates (sadly I don't know which one) have conspired to prevent the Excel filter from saving Word documents in Excel format - which is a shame. The filter will still open Excel format files. Saturday 28th, April 2007 Corrected a typo (thanks to user feedback) on the Alternative Return Addresses page. Thursday 26th, April 2007 Back from a couple of weeks visiting family in the UK and Ireland and an opportunity to record several images for the photo sections on Wales - to include pictures of Llandudno, Colwyn Bay and Harlech - and several additions to the Ireland gallery. Easter Sunday 8th, April 2007 Added a few pictures from last night's celebrations. Good Friday 6th, April 2007 Added some further descriptions to my House For Sale page Monday 2nd, April 2007 Added a link to the downloads page. Friday 30th, March 2007 Fellow MVP and frequent contributor to this site, Doug Robbins, has come up with a vba solution to the problem of Word's inability to fully propagate labels when use on a Tablet PC (and now seemingly some others). Tuesday 20th, March 2007 Added a note to the mail merge graphics web page concerning paths being changed when merging to a new document. Thursday 15th, March 2007 Added a sentence of explanation to the duplex merge page for the benefit of those who don't know what to do with add-in templates. Monday 12th, March 2007 A small addition to the Word field code formatting page, to demonstrate lower case on am/pm switches. Saturday 10th, March 2007 Added some further error trapping in the boiler.dot macro code, and corrected a few typos in the Duplex Postcards page uploaded yesterday. Friday 9th, March 2007 Following some discussion in the Word mail merge forum about the implementation of duplex merges to postcards, fellow MVP Doug Robbins and I came up with some ideas about the implementation of a macro to convert a data file to create such merges. Although the end results were the same, Doug's code was somewhat more elegant than mine, so that has been incorporated into the macro. The explanation takes the form of a new page, accompanied by an add-in to download. Friday 2nd, March 2007 Added a page with macro code to change DATE fields in a document or template (or batch of documents or templates) to CREATEDATE fields, to overcome the common problem of unwanted updating of the date in a document. Wednesday 28th, February 2007 Still picking up the pieces from Monday's server error. I have corrected a minor error in the boiler.zip file and removed some redundant material from the downloads page. Tuesday 27th, February 2007 Anyone accessing my web site today may have found a catalogue of horrors thanks to my Web service provider, One and One, who managed to screw up most of my pages and lose a few others. After telephoning their support (twice), I failed to find a solution. The best they could come up with was to remove the Front Page extensions and use the ftp server to update the site. So half a day wasted, the updated files - without the extensions - are now live. Fingers crossed there will be no more excitement. Please report any anomalies. I have also made some modifications to the boiler.dot downloadable file. I found that the routine to display the filenames did not work reliably, and not at all in Word 2007. The new version should address that. It also now includes the option to insert the documents each to a new page with a new page section break. Sunday 25th, February 2007 Borrowing again from Doug Robbins macro examples, I have added a further example of automatic document numbering to my page on that topic. This is in acknowledgement that the method shown on that page stores the numbering sequence in the Windows registry. For a multi-user application, this method is inappropriate, so I have included macro code that will save the number sequence in an ini file. Wednesday 7th, February 2007 Doug Robbins has updated the split merge add-in to test for the correct type of merge document (i.e the add-in is intended to work only with form letter merges) Monday 5th, February 2007 Added a link to the Dataviz Conversions Plus web site to the Word filters downloads section. This is, as far as I am aware, the only third party Word filter for Lotus Word Pro documents currently available. I have also added a few more cat pictures to the Cats gallery. Saturday 27th, January 2007 Added a few photos to the 2006/7 gallery. Wednesday 23rd, January 2007 As this site becomes more widely usedImages_2004/112-1245_IMG.jpg (currently over 3000 hits a day) the additional traffic costs of running the site increase, therefore to help defray those costs, I have reluctantly taken the decision to add some discreet advertising with the aid of Google Ad Sense, and have taken the opportunity to add Google's search engine to search this site or the wider web, in place of the search facility that I previously employed, which required extra work to maintain. The results can be seen at the top of this page. Monday 22nd, January 2007 Fellow MVP 'Macropod', whose mathematical skills far outweigh mine, suggested some alternative ways of handling negative numbers in calculations. I have added those suggestions to the appropriate page. Saturday 20th, January 2007 Added a couple more cat photos. Saturday 13th, January 2007 Added code to the sample auto macros to fix the problem encountered in Word 2003 where the cursor shrinks for no apparent reason. Following improvements to Acrobat 7 Professional's add-in for Word, I have revised the Acrobat toolbar web page, to take account of the changes. Thursday 4th, January 2007 Let's start the year with an interesting dilemma for Word users. How to add the first word(s) of each page (catchwords) to the footer of the previous page, for which Word does not have an in-built solution? Thursday 28th, December 2006 Spotted the Paphos pelicans at the harbour, so took the opportunity to add a couple of pictures to the 2006 collection. Wednesday 27th, December 2006 Based on user feedback, I have added a macro for creating a backup of the current document to removable media, specifically a flash drive, though it could be a floppy drive given sufficient space on that disc for the file. Added a cat picture! Sunday 24th, December 2006 Took a short break from the festivities to add a further method of adding alternative return addresses etc to envelopes. Saturday 23rd, December 2006 Christmas is upon us and one of 'our' cats, missing since May, has made a return appearance. Wednesday 6th, December 2006 Further modifications to the macro set the printer and trays for envelopes and labels. Monday 4th, December 2006
Based on user feedback from someone who was
having particular problems with wildcard searches for reserved characters, I
have revised the relevant
section of the wildcards tutorial to make the information it contains
clearer ... I hope.
Sunday 3rd, December 2006 Time to reorganize some of the photograph galleries. In particular I have created a new page for the growing numbers of cat pictures, and moved the cat pictures to this new page. Friday 1st, December 2004 Returning yesterday from a business trip to the capital Nicosia, we took the scenic route via Troodos and stopped off near the summit of Mount Olympus, where the light was fantastic for a few photographs. Wednesday 27th, November 2006 Prompted by a question in the Word Usenet forums, I have added a method of using an alternative printer with the envelope/label wizard to the 'Print to a Specific Printer' page. Tuesday 26th, November 2006 My near neighbour Geoff Dutch has just launched a web site featuring the restaurants in our home town, which should prove useful, given that there are hundreds of them. I have added a link to my favourites page, should you be holidaying near here and are stuck for a dining-out idea. Tuesday 15th, November 2006
A few more
photographs have been added, plus a couple of broken link repairs. I
just didn't get round to updating this list of updates. Tuesday 31st, October 2006 The storms still rage, but I found time between power outages to update the extract images from a document web page, as some users had problems locating the extracted files. New example illustrations should resolve this issue. Wednesday 25th, October 2006 Following user requests, I have added a method of constraining the size of graphics merged into labels to the web page on that topic. The method can easily be adapted to any graphic merge where fixed image sizes are required. Thursday 19th, October 2006 First pictures of the latest kittens Friday 13th, October 2006 The major storm which had been rumbling away since yesterday evening arrived this morning with a vengeance, dumping two inches of rain in an hour, accompanied by impressive thunder and lightening. Between them they took out the electricity supply for the district, killed my ADSL link (so it's anyone's guess when I will be able to upload this), and flooded my boiler room. The kittens were not too impressed either. The photos I added today don't do justice to the weather. I have also included my house sale page in the main site menu, to make it easier for potential purchasers to find. I am not desperate to sell the house. It is appreciating in value by just standing empty and the annual bills are small, but if anyone wants a nice holiday home in a pleasant part of Cyprus, you now know where to find it . Monday 2nd, October 2006 Added a new page which demonstrates a method of removing the password from a Word document protected for forms. Thursday 27th, September 2006 Removed the individual page counter from the Word Pages index. Changed the e-mail message warning on the Home Page. Added a note to the Individual Merge Letters page. Tuesday 26th, September 2006 Added a method of enhancing the cardtext switch to format cash amounts in words to the formatting Word fields page. Sunday 24th, September 2006 Users have complained that they are only able to print one page of labels during a merge to mailing labels. The reason is a failure to follow the merge wizard to the end. Further details have been added to the mail merge to labels page. Sunday 3rd, September 2006
When I moved here to Cyprus, broadband was
not available in the village, but after months of struggling with dial-up, I now
have an ADSL connection once again.
Saturday 2nd, September 2006 The counter on my home page bears little relationship to the traffic on the web site, so I thought I would add one to the Word Pages index. Monday 28th, August 2006 Restored a missing graphic to the mail merge graphics page. Saturday 5th, August 2006 Back from holiday in Ireland and the UK, I have added a few photos to the Ireland and Wales galleries. See also the amazing amount of growth that has occurred in my garden during the three weeks I have been away! Sunday 9th, July 2006
Tuesday 4th, July 2006 Added a further example of conditionally inserting graphics to the formatting word fields page. Monday 3rd, July 2006 While not strictly anything to do with the Macrobutton field, I have added code to the tutorial to collect addressee information from a typed letter head and create an Outlook Contacts entry from it, as it fits in with the code examples to recover addresses from Outlook. Wednesday 28th, June 2006 Added extra code to display the print dialog box when printing to an alternative printer. Friday 23rd, June 2006 Following recent newsgroup questions concerning the removal of the 'Attach as Adobe PDF Toolbar' in Word when used as Outlook Editor (or in Outlook for that matter), I have added instructions for its removal on the 'Lose that Adobe Acrobat Toolbar' page. Monday 19th, June 2006 The link to the Simple CD Text Player on my downloads page appears to have lost its source, so I have added the missing file to my own site. Sunday 18th, June 2006 My page fax_from_word.htm is more about using Word with multiple printers than with Fax in particular, but following feedback from a newsgroup item, it seemed remiss that the page doesn't mention how to obtain the fax function in Windows. That has now been rectified. Checking out my home page, my photo (around four years old) was getting a bit long in the tooth, so I have updated it to the present - so that's me aged 59.. Monday 9th, June 2006 Added macro code to the Macrobutton page to demonstrate the insertion of assorted formatted data from Outlook contacts to produce a typical letterhead for personal or business letters. Sunday 4th, June 2006 A couple more photos to add to the collection - street market stalls in Kato Paphos. Saturday 3rd, June 2006 I'm a sucker for cats so, for those who share my enthusiasm, a few more pictures of the latest arrivals. Thursday 1st, June 2006 Some housekeeping involving minor detail changes to a number of pages - nothing that needs to be highlighted except for a note on the page about Word being unable to import PDF files to include the fact that Word can (in conjunction with Acrobat 7 Reader) import single page PDF files as objects. Wednesday 31st, May 2006 A new page to help recover those edited e-mailed Word documents that you unwisely opened directly from the e-mail then saved changes. Monday 29th, May 2006 Following from yesterday's update to the boiler.zip instructions document, I took another look at the add-in itself and added a function to allow the user to choose from which folder the documents are to be selected, which necessitated further amendments to the instructions - which are additionally available in PDF format. Sunday 28th, May 2006 Updated the installation instructions relating to the boiler.zip download. Tuesday 23rd, May 2006 In response to user feedback I have added further notes to the web page concerning the control of the Acrobat 7 COM add-in. Sunday 21st, May 2006 Maybe a little overdue but I have created a 2006 photo gallery and moved the recent images to it. Recent links on this page have been changed to locate the new gallery. Saturday 20th, May 2006 More photos for the 2005/6 Gallery, taken by my daughter on her current visit to the island. Friday 19th, May 2006 Further detail added to the formatting of US Zip codes from Excel merge data in the formatting fields web page. I now have my replacement camera, so a couple of extra photographs have been added to the 2005/6 Gallery. Tuesday 16th, May 2006 Formatting fields information updated to demonstrate a workaround for the problem of empty INCLUDEPICTURE fields displaying the wrong images. Monday 15th, May 2006 Changes to the macro code for the insertion of Outlook data to demonstrate the insertion of a title field and initial. Orthodox Easter Sunday 23rd, April 2006 We have friends over from the UK .... with a digital camera, so a few more pictures for the gallery. Friday 14th, April 2006 Despite damage to my camera, I managed to snatch a couple of snaps of the first of the new kittens. It will be another month before I can get my replacement camera (the brand new Canon Digital Ixus 65) brought over from the UK. Monday 10th, April 2006 Yet another example added to the formatting fields web page shows how to distinguish between numbers or dates and text in a field. Tuesday 4th, April 2006 Small correction made to the Search & Replace with Wildcards page Saturday 1st, April 2006 A further example added to the formatting fields web page. Friday 10th, March 2006 The old Word 2000 images replaced with up to date versions and some minor alterations to the text of the alternative return addresses web page. Thursday 9th, March 2006 Added an alternative version of the saved numbered version macro which stores the version numbers in a text file rather than in the registry. Monday 6th, March 2006 Green Monday a public holiday here in Cyprus and an opportunity to add a few more photos. Wednesday 1st, March 2006 I thought it would be a good idea to include the full range of field switches, for reference, to the formatting fields web page for the sake of completeness. This is largely the information that is included in Word Help. The downloadable versions have been amended to show the additional data. Sunday 26th, February 2006 A cloud of microscopic dust from the Sahara blanketing the island has made going outside unpleasant for the last couple of days, so I used the opportunity to update the installing macros web page with a few more illustrations.. Monday 20th, February 2006 Added a couple of photos. Sunday 19th, February 2006 Encouraged by my American pal and fellow Word MVP Greg Maxey, I have extensively re-worked the automatic numbering of documents macro and have provided the code in a template which can be modified to produce an invoice/order template. Tuesday 14th, February 2006 User feedback indicated that the merge from Outlook tutorial fell a little short when it came to merging to labels. I have therefore added a further section to describe the additional steps needed to merge to labels. Sunday 5th, February 2006 A new page added to demonstrate automatic numbering of documents, for use in numbering invoices etc. Updated the sample macro document to include the macro from the above page. Saturday 4th, February 2006 Added the latest version of the merge to separate documents add-in to ensure that merged graphics are correctly updated. Revised the macro for the Clear Recently Used File List page to verify whether the help assistant is available and to temporarily add-it if not. Added registry patches to the AmiPro and WordStar filters. Monday 30th, January 2006 The What to Do When Word Crashes page has been extensively revised and brought up to date with new illustrations. Friday 27th, January 2006 Added the old Word 6/95 text converter, required by some third party software e.g. Quark. Monday 23rd, January 2006 Updated the label PDF files and their associated zip files to reflect changes that have been made to the web pages they relate to. Added a PDF version for view or download of the special formatting Word fields web page for ease of reference. Sunday 22nd, January 2006 The macro to save separate numbered and dated versions of a document has been updated to store the numbers in the registry to avoid problems where users do not have write access to the root of the C: drive. Saturday 21st, January 2006 Added another section to the special formats for Word fields page to demonstrate the use of a switch with a calculated form field to suppress output when the result is zero. I have also removed the photo gallery related to my new house. No point in giving the light fingered a target to think about. Friday 20th, January 2006 A further update to the merge to separate documents add-in to provide better compatibility with Word XP. This version should also be used if you use Word on a network and do not have write access to the root of the C: drive. Tuesday 17th, January 2006 Added error handling to catch the clicking of the cancel button in the numbered version macro posted Sunday 15th. January. Sunday 15th, January 2006 Added a new page with a macro to enable any document to be saved in separate numbered and dated versions Monday 9th, January 2006 I have discovered that since my move to Cyprus (8 months ago!), PayPal does not offer the facility to accept contributions from users in this country - which shows how few of the tens of thousands of people who accessed the site felt the information provided was worth a contribution to its upkeep. The facility is therefore suspended until PayPal pulls its finger out. Sunday 8th, January 2006 Further revisions to the merge to separate documents feature, and a new version of the add-in posted for download that combines the option to create separate documents with the option to create PDF files. Thursday 5th, January 2006 More revisions to the merge to separate documents feature. Tuesday 3rd, January 2006 More code from Doug Robbins to enable his merge to separate documents add-in to produce separate PDF files in conjunction with Adobe Acrobat (not Acrobat Reader). Monday 2nd, January 2006 Let's start the New Year with an additional tip on how to conditionally insert StyleRef fields into Word documents. Monday 26th, December 2005 Escaped from the clearing up after the festivities to add conditional merge information to the special formatting page and a few photos to the 2005 gallery. Tuesday 20th, December 2005 Probably not the last word on the subject, but Doug has revised the split merge code to accommodate a few of my suggestions, and I have documented the use of the add-in on my Individual Merge Letters page. Monday 19th, December 2005 Doug Robbins has made some improvements to his split merge to separate documents add-in. Revision 7 is now available for download. Saturday 17th, December 2005 Revisited and updated the envelope templates. Tuesday 13th, December 2005 Lucky for some, the 13th of the month has always been good to me, so today I have added fellow MVP Doug Robbin's latest macro code to automatically split mail merge letters into separate documents - as an add-in download. Friday 9th, December 2005 Very minor corrections to the graphics on labels page and updated the site's search engine database. Add a link to the favourites page to the Simple Sudoku game. Sunday 3rd, December 2005 Yet another example of the use of formatting switches Thursday 24th, November 2005 Fixed another incorrectly displayed image on the field formatting page, and included another example of the use of formatting switches. Monday 21st, November 2005 User feedback pointed out a mathematical anomaly in one of the calculated fields on the formatting word fields page. A workaround to correct this error has been added. Sunday 20th, November 2005 Some minor cosmetic improvements to the Wildcard tutorial. Monday 7th, November 2005 Repaired problem that was causing the wrong images to display for the item posted on Friday last. Sunday 6th, November 2005 Some minor modifications to the macro code on the individual merge letters page to ensure consistency in file naming, following user comment. Friday 4th, November 2005 Added a further example to the formatting of fields with a calculation to test for a particular result in one or more mail merge fields. Monday 31st, October 2005 Some people, have reported that the IncludePicture field used in the mail merge graphics tutorial does not work for them. A link has been added to the page which covers this issue when certain named Word versions are used. Sunday 30th, October 2005 Tonya Marshall, whose Word Perfect label converter macros were hosted by this site now has her own web site, so I have changed the links on the downloads page to point to the original files. Sunday 23rd, October 2005 Added the MSDOS Text with layout filter for Word to the downloads page. Friday 21st, October 2005
The kittens
were not taken by the fox after all
Sunday 9th, October 2005
|
- and then I did
some pruning of old and unnecessary stuff, starting with the comedy downloads
that were getting a little dated, and some of the graphics that were linked to
external forums.
I have been
so impressed that I have added a link to the 
I awoke this morning
to two pieces of good news: 
It does not
necessarily mean that I will update the site any more frequently, but when I do,
it is much quicker to upload the changes. Today's change is a minor change to a
graphic on the