Co-Authored By:
If you want to send a mass mailing to anaddress list that you maintain in a MicrosoftExcel spreadsheet, you can use a Microsoft Word mailmerge. The mail merge process creates a sheet of mailinglabels that you can print, and each label on thesheet contains an address from the list.
Simply so, how do I make mailing labels?
Creating your Mailing Labels:
- 1) Start Microsoft Word.
- 2) Click the New Document button.
- 3) From the Tools menu, select Letters and Mailings, thenselect Envelopes and Labels.
- 4) Select the Labels tab, click Options, select the type oflabels you want to create and then click OK.
- 5) Click New Document.
Just so, how do I make labels?
How to Create a Page of Different Labels
- Go to the Mailings tab.
- Select Labels in the Create section.
- Select Options to open Label Options.
- Choose the label brand in the Label Vendors or Label Productslist, then select the product number matching the labels you wantto print on.
- Select OK.
- Select New Document.
Method 2 Using a Print Area
- Open your Excel worksheet. Double-click the worksheet or go to“File > Open” in Excel.
- Highlight the cells that you want to print.
- Go to the “Page Layout” tab.
- Set the Print Area.
- Go to “File” and select “Print”.
- Adjust the print settings.
- Press “Print”.