K D asked in Computers & InternetSoftware · 1 decade ago

How do you convert an excel address list to labels???

2 Answers

Relevance
  • 1 decade ago
    Favorite 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.

    Ready?

    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.

    Everything OK?

    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!

    • Login to reply the answers
  • 1 decade ago

    Wouldn't it be easier to do that in word? Copy you address into word and then print on labels?

    • Login to reply the answers
Still have questions? Get your answers by asking now.