NAPUS

Download Mailing Labels Instructions

Chapter Website Main Menu

  1. Click > Download Mailing Label Merge Files
  2. Click the boxes to Select member types that apply for mailing
    (NOTE: Back Page Labels must be done separately)
  3. Click > Get Labels
    “File Download” box appears
  4. Click > Save
    “Save As” box appears
    Save to “My Documents”
  5. Click > Save
    “Download Complete” box appears
  6. Click > Close
  7. Click > Minimize Button in top right corner
    Exported File will automatically save as (*.csv or *.txt)

Now you need to change your saved file to an EXCEL file (*.xls)

Open EXCEL

  1. Click > File > Open
    “My Documents” should open
  2. Click > down arrow for “Files of type” at the bottom of the box
  3. Click > Text Files (*.prn; *.txt; *.csv)
  4. Click > File you just Exported
  5. Click > Open
  6. Click > File > Save As
  7. Click > down arrow for “Save as type” at the bottom of the box
  8. Click > Microsoft Excel (*.xls)
  9. Click > Save
  10. Click > File > Exit

Create Labels Merge EXCEL (*.xls) File with WORD

Of all the labels available, the recommended is Avery 5160. Open WORD

  1. Click > Tools > Letters and Mailings > Mail Merge Wizard
    MAIL MERGE Menu appears down the right side of your screen
  2. Click > Labels at the top of the column under “Select document type”
  3. Click > Next: Starting Document at the bottom of the column under Step 1 of 6
  4. Click > Label options under “Change document type” at the top of the column
    The “Label Options” box opens
    Select Avery standard and 5160 Address and Click > OK
  5. At the bottom of the column under Step 2 of 6 Click > Next: Select recipients
  6. Under “Select recipients” at the top of the column Click > Use an existing list
  7. Click > Browse under “Use an existing list”
  8. “Select Data Source” box opens Under “Look in” Click > “My Documents”
  9. Select the file you converted to EXCEL (.xls) Click > open
  10. “Select Table” box appears Click > OK
  11. “Mail Merge Recipients” box appears
  12. (Note the column headers that the full name, title, address, and city/state/ZIP are under)
  13. Click > OK
  14. At the bottom of the column under Step 3 of 6 Click > Next: Arrange your labels
  15. Under “Arrange your labels” at the top of the column Click > More items
  16. The Insert Merged Fields” box opens You are now going to set the fields for your label. Substitute your column labels as appropriate.
  17. Click > Label1 (full name) Click > Insert > Close
  18. Click > More items Click > Label2 (Title) Click > Insert > close
  19. Click > More items Click > Label5 (Address) Click > Insert > Close
  20. Click > More items Click > City/State/ZIP Click > Insert > Close
  21. In the middle of the column under “Replicate Labels” Click > Update all labels
  22. At the bottom of the column under Step 4 of 6 Click > Next: Preview your labels
  23. At the bottom of the column under Step 5 of 6 Click > Complete the Merge
  24. At the top of the column under “Complete the merge” Click > Edit individual labels
  25. “Merge to New Document” box opens Select > all Click > OK
  26. A new page opens with your labels.
  27. On the new page with the labels Click > File > Save As
    The “Save As” box opens
    Type a name in the “File Name”
    Click > Save
    You can print your labels now or later
  28. To print Load your labels Click the “Print” icon or Click > File > Print > OK