How do you convert an excel address list to labels???
- williamh772Lv 51 decade agoFavorite Answer
Start Word. Click Tools, Letters and Mailings, Mail Merge Wizard... The task pane will open on the RHS of your screen. This is the first of 6 steps/panes.
Click the radio button for Labels. At the bottom of the pane click Next: Starting document.
In the next pane, click 'Label options...' and choose the exact one. Click Next: Select recipients.
Now, navigate to the Excel worksheet. When the Mail Merge Recipients dialogue box opens, make sure that all of the names that you want to appear on the labels are checked along the LHS of this list.
Click Next: Arrange your labels
Is there an address block or are you entering each item (merge field)? If so, click More items.. and (in the Insert Merge Field dialogue box) select the first item, click the Insert button (at the bottom of the dialogue box) and the Cancel button to the right of this will change and say Close--click this Close button. Be sure to hit the space bar one time before entering the next merge field (or the text on your labels will run together). Repeat this process for the next merge field, and so on.
Now click the 'Upgade all labels' button.
Click Next: Preview your labels
Here you can click the forward and back symbols to the right and left of Recipients to see each name.
Click Next: Complete the merge
Click Print... and the Merge to Printer dialogue box opens. Click the All button and click OK. The Print dialogue box will open. Click OK.
That should do it!
- 1 decade ago
Wouldn't it be easier to do that in word? Copy you address into word and then print on labels?