Sorting labels doesn't have to be laborious. If you have an existing data source file, you can sort them before they are printed. The source file is the list containing the information you want to pull, created in Word, a spreadsheet, database or address book. If you use it in combination with a mail merge, you'll have the option to sort up to three fields in ascending or descending order. Any modifications you make are applied to your labels.
Start a new document in Word 2007.
Video of the Day
Select the "Mailings" tab. Click "Start Mail Merge" and "Step by Step Mail Merge Wizard."
Select "Labels" in the Mail Merge task pane. Click "Next."
Click "Use the current document" or "Start from existing document." To modify the current document, select "Label options," choose your label settings and click "OK." To modify an existing document, click "More files," double-click the file you need and click "Next."
Select "Use an existing list" and click "Browse."
Double-click the data source file containing your label content (such as names and mailing addresses). Go to the "Refine recipient list" section in the "Mail Merge Recipients" dialog box and click "Sort."
Select the "Sort Records" tab in the "Filter and Sort" dialog box.
Click the pull-down menu beside "Sort by" and select the first field (in priority order) you wish to sort. Choose "Ascending" or "Descending."
Click the pull-down menu beside "Then by" and select the next field you wish to sort, in priority order. Choose "Ascending" or "Descending." To sort a third field, go to the next "Then by" option, choose your sorting preferences and click "OK."
Click "OK" to close the "Mail Merge Recipients" dialog box.
Click "Next: Arrange your labels."
Click "More items" to open the "Insert Merge Field" dialog box. Double-click any fields you want to add to the label and click "Close."
Go to the label sheet and arrange each field the way it should appear on the label. For example, you can insert a space between the first and last name.
Return to the task pane and click "Update all labels."
Select "Next: Preview your labels."
Select "Next: Complete the merge."
Select "Print" or "Edit individual letters." Click "OK" in the "Merge to Printer" or "Merge to New Document" dialog box to complete the merge for your sorted labels.