Share via

Printing multiple pages of labels at a time using mail merge in Word 2010

Anonymous
2010-12-09T19:43:34+00:00

In using mail merge in Word 2010 I am unable to print more than one page of lables at a time for my mailing list.  I am using an Excel 2010 list as my data source, and my operating system is Windows 7.  Any ideas?

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
2010-12-09T20:30:30+00:00

How are you going about trying to do it?  On the Mailings tab are you using the Finish & Merge facility in the Finish section of the Ribbon?  If you do click on that button, you will be given the options to execute the merge directly to the printer, or the misleadingly named "Edit Individual Documents", which actually creates a new document containing labels for all of the records from your data source.  You can then print that document, or as many copies of it as you want.

I guess there is also the possibility that the reason that you are only able to print one sheet at at time is because your printer has problems feeding the label sheets. If that is the case, it is nothing to do with mail merge.

Was this answer helpful?

90+ people found this answer helpful.
0 comments

17 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-12-12T20:59:05+00:00

    Wow.  I was using the Mail Merge Wizard and never in a million years would I have thought to click on "Edit Individual Documents" on the ribbon to get all the mailing labels into one document --- it's just so non-intuitive. (And I can't possibly be the only knuckle-head who's had this issue.) 

    Thanks for your help, Doug!

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2014-01-09T03:59:43+00:00

    In a label merge, which is what this thread discusses, each page usually equals one section, so you could simply use s1-s5, for example, to print pages 1-5.

    For a letter merge, all you need know is which records (i.e. Sections) to print and use the same approach as above - you'd only need to specify the page# part if you wanted to print, say, page #2 from each letter.

    For Directory/Catalogue merges, one doesn't normally generate Section breaks, so it's be back to page #s for printing.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2012-12-18T20:00:59+00:00

    Actually you can just create a copy and save it with 1 of the letters. You just have to select the "Edit Individual Documents" option under the "Finish & Merge button" and instead of "all" in the pop up box enter the page number you want, to open in a separate screen in the "from to box." Also thanks for the information of the "Edit" button. I was wracking my brain and others too trying to figure out a solution. lol! :) Have a wonderful day and holiday!!

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Suzanne S Barnhill 277.5K Reputation points MVP Volunteer Moderator
    2010-12-12T21:51:26+00:00

    No, you absolutely aren't the only one. I've complained for years about the deceptive wording of that inconspicuous link/button.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments