Convert a list of address to a mail merge document

Download the MergeLabelFix add-in from the following page of my OneDrive:

http://bit.ly/1hduSCB 

The file needs to be saved in the Word Startup folder.  In Windows XP the default location for that folder is

C:\Documents and Settings\[User Name]\Application Data\Microsoft\Word\STARTUP

In Windows Vista and Windows 7, 8 or 8.1 it is

C:\Users\[User Name]\AppData\Roaming\Microsoft\Word\STARTUP

If you do not see the AppData folder: -

In Windows 7, - In Windows Explorer, click on the Organize drop down and then on Folder and search options and in the Folder Options dialog, go to the View tab and select the item "Show hidden files, folders, and drives".  While there, it is a good idea to uncheck the box of "Hide extensions for known file types".

In Windows 8 and 8.1, in the File Explorer, click on Options on the View tab of the ribbon and then on the View tab in the dialog that appears and select the item "Show hidden files, folders, and drives".  While there, it is a good idea to uncheck the box of "Hide extensions for known file types".

After saving it there, either re-start Word or go to the Developer tab and click on Document Template and place a check beside the MergeLabelFix.dotm item that you should see in the list of Add-ins.

The code in that add-in replaces the Update labels utility with a routine that will populate all of the labels on the sheet with the data that is set up in the first label.