Co-Authored By:
Asked by: Lotte Oquiñena
events and attractions weddingHow do you mail merge labels from Excel to Word 2007?
Creating Address Labels in Word 2007
- Before you start make sure you have your Excelspreadsheet ready.
- Next, click on the Start Mail Merge button and selectLabels.
- Now it's time for you to select the Label Vendor.
- Next, click on the Select Recipients button on the ribbon andselect Use Existing List.
Correspondingly, how do you do a mail merge in Word 2007 for labels?
Microsoft Word 2007 Mail Merge
- Open on the "Mailings" tab in the menu bar.
- Click "Start Mail Merge."
- Select "Step by Step Mail Merge Wizard."
- Ensure "Change document layout" is selected and click "Next:Select recipients."
- Open a blank Word document.
- Go to the Mailings tab, choose Start Mail Merge and click onLabels.
- Choose the brand in the Label Vendors box and then choose theproduct number, which is listed on the label package.
- Click OK when you are ready to proceed.
Also to know, how do I use mail merge to print labels?
Print labels for your mailing list
- Go to Mailings > Start Mail Merge > Labels.
- In the Label Options dialog box, choose your label supplier inthe Label vendors list.
- In the Product number list, choose the product number on yourpackage of labels.
- Choose OK.
- Go to File > Save to save your document.
Creating your Mailing Labels:
- 1) Start Microsoft Word.
- 2) Click the New Document button.
- 3) From the Tools menu, select Letters and Mailings, thenselect Envelopes and Labels.
- 4) Select the Labels tab, click Options, select the type oflabels you want to create and then click OK.
- 5) Click New Document.