Merging a Microsoft Excel spreadsheet into Microsoft Word to create mailing labels can make large mailings easier, but if you need to undo the merge later, the process can take anywhere from a few seconds to more than a couple of minutes, depending on where you were in the process. If you have a simple correction, such as a single address change, you can change the address directly in the merged Word label document, overriding the information from the Excel spreadsheet.
Make sure the original Excel spreadsheet information was saved before you created the merge.
Close the Word document featuring the mailing labels.
Open the old Excel spreadsheet. This option will only work if you have not saved the mailing labels in their merged state.
Click the curved undo button at the top of the screen in Excel. This should bring up a list of all the options you can undo, including the merge, as long as it's recent.
Click the undo button until the document is no longer merged.
Review your spreadsheet and add any information that was changed after the document was merged into the spreadsheet.
Convert an old mail merged batch of labels into an Excel or Word spreadsheet. Click on the table tab in your merged Word 2007 or Word 2010 mailing labels.
Choose "convert." You should have two options "convert text to table" or "convert table to text." Choose "convert table to text." Separate each line of each address with a paragraph marker, when the prompt requests a way to separate text.
Choose a unique symbol to put at the end of each address, such as the per cent sign. Add it to the end of each line using Find and Replace.
Replace the paragraph marks and unique symbols with tabs by using find and replace. Remove the unique symbols and paragraph marks from the fields in find and replace, leaving nothing in the field boxes. A single paragraph mark should be left at the end of each address line.
Open Excel 2007 or 2010. Choose the "data" tab. Click on "from text" under the "get external data" section of the tab. Choose the Word text document with the information. Follow the prompts to provide any additional cell separations that you may need in your Excel document.
In newer versions of Word, you can skip adding paragraph marks and make the separations when you pull the text over to Excel.
Always save your work before you begin a new process, such as a mail merge.
Tips and warnings
- In newer versions of Word, you can skip adding paragraph marks and make the separations when you pull the text over to Excel.
- Always save your work before you begin a new process, such as a mail merge.