Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. He is a regular guest on TechTV with Leo Laporte and is the host of, which includes more than 300,000 questions and answers about Excel. MVP Bill Jelen is the author of more than two dozen books about Microsoft Excel.
' Update the row and column for the next label However, when you are ready to print labels, you LL needs to use mail merge to create. LabelSheet.Cells(ThisRow, NextCol).Value = CitySt , you can use Microsoft Excel to organize a mailing list neatly. If AddressSheet.Cells(i, 4).Value > "" Then ' Put the City, State, Country/Region and Postal code in row 4 LabelSheet.Cells(ThisRow, NextCol).Value = AddressSheet.Cells(i, 3) To do this, you’ll need to create columns for each bit of address information.
Step 1 Making Your Microsoft Excel Worksheet To begin with, you’ll need to make your Excel Worksheet filled with the address details.
Make sure: Column names in your spreadsheet match the field names you want to insert in your labels. Here are some tips to prepare your data for a mail merge.
If AddressSheet.Cells(i, 3).Value > "" Then Below are the steps on how to print 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. LabelSheet.Cells(ThisRow, NextCol).Value = AddressSheet.Cells(i, 2) If AddressSheet.Cells(i, 2).Value > "" Then LabelSheet.Cells(ThisRow, NextCol).Value = AddressSheet.Cells(i, 1) & " " & AddressSheet.Cells(i, 7) LabelSheet.Cells(NextRow + 4, 1).RowHeight = 13.25 LabelSheet.Cells(NextRow, 1).Resize(4, 1).RowHeight = 15.25 Set AddressSheet = Worksheets("Addresses")įinalRow = AddressSheet.Cells(65536, 1).End(xlUp).Row You can also select New Label if you want to enter custom label dimensions. The addresses are rearranged and copied onto the Labels sheet. Choose the brand in the Label Vendors box and then choose the product number, which is listed on the label package.
Note: If you are using a continuous-feed printer, youll have a. The addresses on the Addresses sheet must be arranged as one address per row, with the Name in Column A, Address Line 1 in Column B, Address Line 2 in Column C, and the City, State, Country/Region and Postal code in Column D. The mailing list can be an Excel spreadsheet, a directory of Outlook contacts, an Access. The workbook must contain two sheets, one named "Addresses" and one named "Labels". The following code example takes a list of addresses arranged as one address per row, and copies them onto another sheet, arranging them to fit on printable address labels.