Here's how to do it:
- Start a new Word file and navigate to the Mailings tab.
- Click Start Mail Merge > Labels.
- Select the label type based on the brand and product number printed on your label sheet, then click OK.
- Click Select Recipients > Use an Existing List.
- Locate your Excel file, and ensure the data is on the first sheet.
- Use Insert Merge Field to add fields like First Name, Last Name, Address, and City to the label template, ensuring proper spacing between fields.
- Click Update Labels to apply the format to all labels.
- Select Finish & Merge > Edit Individual Documents to preview and edit the labels.
- Specify the number of labels you want to print (e.g., 1–10) and click OK to print your labels.
