Open your Excel file and make sure each column has a clear header, such as Name, Address, City, State, and ZIP
Clean and verify the data so each row contains one complete mailing address
Save the Excel file
Open Microsoft Word
Go to the Mailings tab
Select Start Mail Merge
Choose Labels
Select the label vendor and product number, or create a custom label size
Click Select Recipients
Choose Use an Existing List
Browse to your Excel file and open it
Select the correct worksheet and check that the first row contains headers
Insert the address fields into the first label using Insert Merge Field
Format the label layout as needed
Click Update Labels to apply the layout to all labels
Use Preview Results to check the merged data
Complete the merge by choosing Finish & Merge
Select Edit Individual Documents or Print Documents
Print the labels on label sheets
Save the Word mail merge document for future use
