TO PREPARE AND RUN MAILING LABELS

 

The following instructions allow you to merge names and addresses from a data file (from Word, Excel, or other) with a label format in Word to produce mailing labels for each name and address in your data file. These steps should work as shown in Office 2003 and 2007 and similarly in prior versions of Office. If you do not get mailing labels it is likely that your data file cannot be read properly by Word.

 

1.      Open Word to blank new document.

2.      Office 2003: Click TOOLS - LETTERS AND MAILING - MAIL MERGE
Office 2007: Click MAILINGS - START MAIL MERGE - STEP-BY-STEP MAIL MERGE WIZARD (at bottom of list).

3.      Click Labels on the right side of the screen.

4.      Click Next: Starting Document at Step 1 of 6.

5.      Click Label Options.

6.      Scroll down in Product Options box and click 5260 Address (or other). Note: Look on box of labels for correct choice.

7.      Click OK.

8.      Click Next: Select Recipients at Step 2 of 6.

9.      Click Use an Existing List.

10.  Click Browse.

11.  Switch to location of data for labels.

12.  Double-click on name of file (data for labels). (Note: Click OK if you get a message that a record contains too many fields.)

13.  Click OK in Mail Merge dialog box.

14.  Click Next: Arrange Your Labels at Step 3 of 6.

15.  Click More Items.

16.  Click Name in Fields list and click Insert.

17.  Click Address in Fields list and click Insert.

18.  Click City, State, Zip in Fields list and click Insert.

19.  Click Close.

20.  Click in the middle of the >><< symbols between Name and Address and press ENTER.

21.  Click in the middle of the >><< symbols between Address and City, State, Zip and press ENTER.

22.  Click Update all Fields button.

23.  Click Next: Preview Your Labels at Step 4 of 6.

24.  Click Next: Complete the Merge at Step 5 of 6.

25.  Insert label stock in printer.

26.  Click Print at Step 6 of 6.

27.  Click All.

28.  Click OK.

29.  Click OK again.