"
![]() |
![]() |
![]() |
If you have more than one page of mailing labels in a document, it becomes difficult to maintain. The labels should be converted to a mail merge data source which can be merged to create a new label document.
In the following examples I have toggled-on the formatting information (CTRL+SHIFT+8 - or click the ¶ button on the Home tab of the Word ribbon) to demonstrate more clearly what is happening.
The first step is to extract the addresses by converting the table to text. In Word versions to 2003, click in the table and from the Table menu select Convert > Table to Text.
In Word 2007/2016 select the table then click Convert to Text on the Data section of the Layout Tab of the ribbon. The button positions vary with version, but the command is at the right hand side of the ribbon.
Using paragraph marks as record separators (see above), the result should appear like the first of the two examples below.
If, like the
right column example, it has the
marks that indicate 'soft returns' against some of the address lines,
then you must use the replace function to replace ^l (lower case L - which represents
) with ^p (which represents ¶), to produce a result similar to that of the left column.
If each label had the same number of address lines, you could simply convert back to a table now, but they rarely do, so we now need a few more steps to complete the process. First step is to insert a marker that will hold the ends of each address. Each address is terminated by (at least) a double paragraph mark, so we can run a wildcard search to replace that double paragraph mark with a random and unique string of characters to produce the result below. On reflection, '@' was not the most ideal choice as it is a reserved character in searches, but we can work round that one.
For more information on wildcard searching in Word see https://www.gmayor.com/replace_using_wildcards.htm
Next step is to swap those paragraph marks for tabs, to put each record on its own line. The search string looks for each paragraph mark and the character preceding it, but *not* characters preceded by @. The replacement string restores the preceding character and adds a tab in place of the paragraph mark.
The result is as follows:
Next step is to lose the marker. Use a simple search, without the wildcard option, to replace the marker with nothing:
You can now select the list and again from the Word 2003 Table menu, convert the selected text back to a table.
In Word 2007/2016 the convert text to table command can be found on the Insert Tab of the ribbon after clicking Table:
Thereafter whichever Word version you use the dialogs are similar.
Add a title row at the top of the table. The names are not critical, just make them memorable and unique.
Save the finished table and you have a data source that is easier to maintain and which Word can use to create a new label merge.
Better still copy the table to an Excel worksheet for even more versatility.
Below is a macro based which adopts a different approach and which includes a few corrections for matters that might pop up along the way, then saves the results as a sorted data source. The macro has been tested on a variety of (but not all possible) label layouts in both Word 2003 and Word 2007, so please test it on a COPY of your label document.
Before discovering the pleasures of mail merge, it is not unreasonable to type addresses into mailing labels as in the first illustration alongside. Such a document is however difficult to manage, should you wish to add further addresses, and the benefits of mail merge quickly become apparent - but maybe not if you have to retype all those addresses.