How to Print Mailing Lists
Microsoft Office tools help you create and print mailing lists for business and personal use. You can print mailing lists on paper, or labels for faster mailing times. To print your mailing list, merge information from a saved document using either Outlook or Microsoft Excel spreadsheets. Use Outlook with few contacts. Excel handles larger lists in a more organized fashion.
Other People Are Reading
Instructions
-
-
1
Save your mailing list in either Outlook or Excel. Provide headers for your list such as first name, last name, address and the proper zip codes. Close out of the program.
-
2
Open Microsoft Word in a blank document. Select "Tools" at the top, left hand corner of your document. From the drop-down menu, select "Mail Merge." This will generate another list of options.
-
-
3
Click on "Create" to designate the mailing list style you wish to print out. A drop-down menu will appear with the options for labels, envelopes, form letters and catalogs. Click on your desired form from the menu.
-
4
Click on the arrow next to "Data Source." This will bring another drop-down menu onto your screen. Click on "Open Data Source" to access your saved Excel or Outlook document.
-
5
Navigate your documents library until you find the desired document and highlight the file. Click "OK" to transfer the document to your mail merge. If prompted to choose your delimiter, use the exact one that you want to have separate the information in the document. This determines the print layout for your particular type of list.
-
6
Click "Merge" to transfer your list to your Word document. Once the merge goes through successfully, check your list to ensure its accuracy and proper set-up.
-
7
Click "File" at the top left of your screen or, if you wish, the printer icon. Choose "Print" from the drop-down menu. Verify the correctness of your parameters given your paper or label size. Click "OK" to begin printing.
-
1
References
- Photo Credit Patrick Ryan/Lifesize/Getty Images
