how to print address labels with MS word based on datas merged from access or excel?

On each page, there will be few rows of labels, and all of them should not be identical.

It should be one after the other following the list.

3 Answers

  • 1 decade ago
    Favorite Answer

    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, do you have an existing list, or an Access database with the data (that you can browse to), an Outlook Contact list, or do you want to type in the list now (here you must click the Create button and enter each one [recipient])?

    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.

    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

    Excel is the easiest to use for Mail Merge. Go into excel and type the name/label on the first line row of data. Highlight the row and make it bold so that it can be recognised as being a header. you can then put all the information for example, names, addresses and telephone numbers for as many people as is required for the mail merge.

    Next go into Word and Tools, Leeters and Mailings and select Mail Merge - in stept 2 select "Select the recipients" and use from an existing list.

    This will bring up a box to slect from data sources - use the drop down menu to select Excel or .xls file. You can then look in the area where you have saved your Excel spreadsheet.

    • Login to reply the answers
  • 1 decade ago

    well it depends, i do labels also for work, but i download a template from and on the search bar you can but lables mabye that can does for me, or sometimes you can put the label name for example Avery 5160.......

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