Writing

  • Preserving spreadsheet integrity

    In a previous article I wrote about the risk of sorting only some of your columns in an Excel spreadsheet. You can obviously make a backup copy of a spreadsheet, which is never a bad idea, especially if it’s a complex document with multiple tabs. But when working with a mail merge, whether you’re using…


  • Safe sorting strategy

    When working with large mailing lists, the worst fear is surely that the list will become corrupt because not all of the columns are sorted at once. Microsoft Excel will attempt to warn you if it appears you’re not sorting all the columns. But if you end up with an empty column in the middle…


  • A mail merge fresh start

    One of my favorite mail merge best practices is giving your mail merge a fresh start. For those of us who live in multi-tabbed Excel sheets, it can be tempting to just direct the fields in your letter or document to the right tab. But as your mail merge projects get more complex, it is…