How do I create and print mailing labels from my Org's Contacts Database?
Before you begin this process, you will want to be sure to have ready a supply of mailing labels. We recommend using Avery’s “5160 - Address” labels, or their equivalent from any other mailing label vendor.
- From Contacts, export the list of contacts you want to use for the mailing labels [see Advanced Search / Filtering for creating lists].
- Start Microsoft Word and open a new blank document. From the Tools menu, select “Letters and Mailings” then “Mail Merge Wizard”.
- In the right-hand column next to the document, Select the document type: “Labels” and click “Next: Starting document”.
- Click “Label options…” and select Label products: “Avery standard”. Then select Product number: “5160 – address” Click “OK” and then “Next: Select recipients”.
- Choose “Browse”, select the CSV file you saved and click “Open”. Then click “OK”.
- To sort your labels, you can now click on the column name that you would like to sort by. The NAME field will sort by last name, or you can scroll to the right and sort by ZIPSORT. Click “Next: Arrange your labels”.
- Under Arrange your labels, Click “More Items” and Insert the following fields from near the bottom of the list: FIRST NAME, MIDDLE NAME, LAST NAME, STREET ADDRESS, STREET ADDRESS 2, CITY, STATE, POSTAL CODE. Then click “Close”.
- Edit the label layout in the upper left to insert returns, a comma between CITY and STATE, and spaces as appropriate.
- Click “OK”, click “Update all labels” and click “Next: Preview your labels”.
- When everything looks OK, click “Next: Complete the merge”.
- Click “Print” to send your labels to the printer.
Comments
0 comments
Article is closed for comments.