Creating Mailing Labels – Word 2007
This document is a guide to create mailing labels from a Microsoft Excel file. An Excel file is a typical format given to clients as output from a Hyperion report. Avery labels 5160 should be used with these instructions. 1. Open Microsoft Word 2007. 2. Click on the Mailings tab.
3. Click the Start Mail Merge icon (A) within the toolbar. In the dropdown menu that appears, choose Step by step mail merge wizard in drop down (B); the Mail Merge menu will appear on the right side of your screen.
4. In the Mail Merge menu, under Select document type, choose Labels then, at the bottom of the menu, click the Next: Starting document link.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu
Page 1 of 8 Updated: 01/16/2008
5. Under Select Starting Document choose Change document layout (A). Then, under Change document layout, click Label options... (B).
6. Within the Label Options box: Under Printer information, select the option appropriate for how you will feed your labels into your printer. Typically, these settings will be Page Printers selected and Tray = Manual feed. Under Label information the following must be selected, Label vendor = Avery US letter and Product number = 5160. Click OK. After clicking OK, a label grid will appear on your document.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu Page 2 of 8 Updated: 01/16/2008
7. At the bottom of the Mail Merge menu, click Next: Select recipients.
8. Under Select recipients choose Use an existing list (A), then under use an existing list click Browse (B); the Select data source box will appear.
9. Within the Select data source box, find your Excel file and double click it.
10. The Select table box will appear with the name of your file; click OK. The Mail merge recipients box will appear.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu
Page 3 of 8 Updated: 01/16/2008
11. Within the Mail Merge Recipients box you will see all of the data within your Excel file. If your Excel document was sorted according to which entries had 3 line addresses and which had 4, you will want to select the entries with one or the other type of address; later you will go back and do the other type. NOTE: To unselect the entries you do not need for this run, click the checkmark in the row for a recipient and it will disappear (A). Click OK when ready (B).
12. At the bottom of the menu box, click Next: Arrange your labels.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu
Page 4 of 8 Updated: 01/16/2008
13. To arrange your labels you will use the first label box on your document as a guide. To add recipient information to the label, click the location of the first label, and then, in the right menu bar, click Address block; the Insert Address Block box will appear.
Under Specify address elements: o Insert recipient’s name in this format: a checkmark should be in this box and in the dropdown select the format for how you would like names to appear on the labels o Insert postal address: a checkmark should be in this box o Format address according to the destination country/region: a checkmark should be in this box
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu
Page 5 of 8 Updated: 01/16/2008
14. At this point, your Preview box (A) will still not appear as it should with name and address. Under Correct Problems, click the Match Fields button (B); the Match Fields box will appear.
In the Match Fields box, go through the options (using the dropdown boxes) and match each Excel field to the appropriate field in Word. The Word fields are listed on the left side and the Excel fields will be available to choose via the dropdown boxes. o If some Word fields are not present in your Excel file leave that dropdown to (not matched). o When done, click OK. After clicking okay, the Insert Address Block should now contain a preview with your first label. If information appears as it should click OK, if it does not, go back to Match Labels and make any corrections needed.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu
Page 6 of 8 Updated: 01/16/2008
An example of a typical preview screen with all appropriate information:
15. Click the Update all labels button under Replicate labels; <
> will now appear in all of your label boxes.
16. At the bottom of the right menu bar, click Next: Preview your labels; a document with all of your labels will appear.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu
Page 7 of 8 Updated: 01/16/2008
17. At the bottom of the right menu, click Next: complete the merge.
18. Under Merge click Edit Individual labels, the Merge to new document box will appear, click All then OK. Another document will open with your labels within it. Save this new document.
If you have additional labels to merge (e.g. you did 3 line and now you need to do 4 line), after saving the document close it and find your original Word document. Your screen should still be on where you selected to Edit Individual Labels. At the bottom of the menu, click Previous: Preview your labels. Under Make changes, click Edit recipient list, the Mail merge Recipients list will appear. Go back up to step 11 and go through the process again. NOTE: With 4 line addresses, your bottom line will most likely fall off of your labels. You will need to alter the font size of your document to accommodate for this. Within the Home tab’s Editing box, click Select > Select All In the Font box, select a size that allows all of a label’s lines to fall within the label boundaries; size 10 typically will do this.
Mailing Labels – Word 2007 Questions? adminsys@memphis.edu Page 8 of 8 Updated: 01/16/2008