How To Make Address Labels From Excel

Use the excel sheet which has a tiny macro to rearrange the column data to the printable address labels.

How to make address labels from excel. To create and print the mailing labels you must first prepare the worksheet data in excel and then use word to configure organize review and print the mailing labels. Remember where you saved this file as youll need to be able to find it when it comes time to import it into word. Figure 18 excel spreadsheets to labels. Click the file menu select save as then type a name for your datawhen youre finished click save.

After youve entered all of the addresses for your labels youll need to save the file so it can be imported into word. Press ctrle to start the excel macro. Enter data into column a. How to make address labels with excel step 1.

You can add other information such as phone or email if desired. Open a blank spreadsheet. In the insert address block dialog window we will click on desired options and check the result under the preview section before selecting ok. In select document type choose labels and then click next at the bottom of the screen step 3.

Select the first label switch to the mailings tab and then click address block in the insert address block window that appears click the match fields button. Enter the names addresses and other information of the people for whom you want to make address labels. In the mail merge pane we will click on address block. The mail merge process creates a sheet of mailing labels that you can print and each label on the sheet contains an address from the list.

Open a blank word document. In the required for address block group make sure each setting matches the column in your workbook. The match fields window will appear. Select the brand of labels youre printing on in change document layout choose label options.

And choose the kind of address label you plan to print on.