Comment créer des étiquettes dans Word à partir d'une liste Excel

Introduction

If you’re looking for a simple way to print address labels, product tags, or organize items, merging data from Exceller into Mot is an efficient solution. Here’s a step-by-step guide to help you create custom labels with ease.

Step 1: Set Up Your Excel File

Start by preparing your Excel spreadsheet:

• Structure Your Data: Use the first row for headers like First Name, Last Name, Address, etc.
• Input Label Information: Each following row should contain the information for one label.

• Save Your File: Give it a clear name and keep it somewhere easy to find.

Step 2: Open Microsoft Word

• Launch Microsoft Word.
• Create a new blank document where you’ll design the labels.

Step 3: Go to the Mailings Tab

• Click the Mailings tab in the Word ribbon. This is where you’ll find all the tools you need for label creation.

Step 4: Open the Labels Setup

• Click Labels in the Mailings tab.
• A pop-up window will appear. Here, click on Options to choose your label layout.

Step 5: Set Up Label Details

• Choose your Label Vendor (e.g., Avery) and select the matching product number.
• If your label type isn’t listed, select New Label and enter the dimensions manually.
• Make sure the Full page of the same label is selected.

Step 6: Connect Your Excel Data

• Click Select Recipients > Use an Existing List.

• Locate and open your Excel file.

• Confirm the worksheet and data range that Word detects. Adjust if needed.

Step 7: Add Merge Fields

• Click Insert Merge Field and choose the fields you want to appear on each label (e.g., First Name, Address).
• Arrange the fields in the label layout as you want them to print.

Step 8: Preview Your Labels

• Click Preview Results to see how each label will look with your Excel data.
• Use the arrows to scroll through and make sure everything is aligned correctly.

Step 9: Finalize and Print

• Click Finish & Merge > Print Documents.

• Choose your printer settings and make sure your label sheets are loaded correctly.

• Hit OK to start printing your labels.

Conclusion

Merging Excel data into Word labels is a great way to simplify tasks like mass mailing, inventory tagging, or organizing documents. Once set up, this method saves time and ensures consistency across all your printed labels.