How to format a mailing list using Word 2007 or later

How to format a mailing list using Word 2007 or later

SUMMARY

This article demonstrates how to format an exported mailing list in Word 2007 or later. This is useful if printing mailing labels on labels other than the internally supported Avery 5161.

MORE INFORMATION

Important The method below requires you have Microsoft Excel and Microsoft Word installed on your computer.
  1. Click Lookup on the top toolbar.
  2. Click Extended on the top toolbar. The Search Field Setup window will open.
  3. Click the Reports button. The Saved Reports window will open.
  4. Click Mailing Labels by Site and then click Load.


  5. Click Load.
  6. Click OK to run the report.
  7. On the top bar, click Export.



    Microsoft Excel will open.

  8. In Microsoft Excel, click on Edit->Replace.


  9. In the Find what box, type “-0000-000”. Leave the Replace with box empty. Click Replace All.



    This will format the ZIP code properly.

  10. Click Close.
  11. Search the document and manually delete any blank rows.
  12. Click on File.
  13. Click Save As. In the Save as type list, choose “CSV (Comma delimited (*.csv)”.
  14. Browse to the desktop and click Save (if a File Format warning dialog appears, click Ok).
  15. Close Excel.
  16. Open Microsoft Word.
  17. Click on Mailings->Start Mail Merge.


  18. Select Step by Step Mail Merge Wizard….


  19. On the right-side of the screen, select Labels under Select document type.


  20. Click Next: Starting document.
  21. On the right-side of the screen, select Change document layout under Select starting document and then click Label options.


  22. Choose the appropriate mailing labels and click OK.
  23. Click Next: Select recipients.
  24. On the right-side of the screen, select Use an existing list under Select recipients and then click Browse....


  25. In the Select Data Source window, browse to the file saved in step 13 of this document and click Open.
  26. In the Mail Merge Recipients window, click on the column the labels t0 use for sorting and then OK.
  27. Click Next: Arrange your labels.
  28. On the right-side of the screen, select More items… under Arrange your labels.


  29. Double-click on the fields desired to be on the labels. The following are recommended:

    • First_Name
    • Last_Name
    • SP_First_Name
    • SP_Last_Name
    • Address
    • City
    • State
    • Zip

  30. When all fields are selected, click OK.
  31. Edit the fields on the Word document so they are in a correct mailing format. Note: Verify there is a space between items on the same line. It can be difficult to see the lack of a space. Suggested format is:

  32. Click the Update All Labels button.
  33. Click Next: Preview your labels.
  34. Verify the labels are appearing in the desired format.
  35. Click Next: Complete the merge.
  36. Microsoft Word will show the first page of mailing labels.
    1. To see all pages, click Edit Individual Labels.
Note: It is recommended to initially print the labels on blank paper to ensure the text aligns properly on the mailing labels.

    Still can't find the answer?