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.
Step 1
Start a new document in Word 2007.
Video of the Day
Step 2
Select the "Mailings" tab. Click "Start Mail Merge" and "Step by Step Mail Merge Wizard."
Step 3
Select "Labels" in the Mail Merge task pane. Click "Next."
Step 4
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."
Step 5
Select "Use an existing list" and click "Browse."
Step 6
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."
Step 7
Select the "Sort Records" tab in the "Filter and Sort" dialog box.
Step 8
Click the pull-down menu beside "Sort by" and select the first field (in priority order) you wish to sort. Choose "Ascending" or "Descending."
Step 9
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."
Step 10
Click "OK" to close the "Mail Merge Recipients" dialog box.
Step 11
Click "Next: Arrange your labels."
Step 12
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."
Step 13
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.
Step 14
Return to the task pane and click "Update all labels."
Step 15
Select "Next: Preview your labels."
Step 16
Select "Next: Complete the merge."
Step 17
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.
Video of the Day