Mail merge labels 8 per page, but 84 is not divisible by 8

Discussion in 'Word' started by Johanna, May 23, 2018.

  1. Johanna

    Johanna

    Joined:
    May 23, 2018
    Messages:
    2
    Likes Received:
    0
    Location:
    Australia
    I can make the merge print all 84 labels, but only if I add four 'false' records numbered 85 to 88 on the Excel database.
    How can I make it create the last page of labels when the page would not be a 'full' page of labels?
     
    Johanna, May 23, 2018
    #1
    1. Advertisements

  2. Johanna

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    394
    Likes Received:
    35
    An ordinary label merge will output as many labels as you have data for, regardless of whether all the labels on the last page get used. Are you actually executing the merge, rather than just previewing it?
     
    macropod, May 23, 2018
    #2
    1. Advertisements

  3. Johanna

    Johanna

    Joined:
    May 23, 2018
    Messages:
    2
    Likes Received:
    0
    Location:
    Australia
    I am actually executing the merge (but not printing it). The execution gives me ten pages, each of eight labels. The last four labels just fail to appear.
     
    Johanna, May 23, 2018
    #3
  4. Johanna

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    394
    Likes Received:
    35
    That behaviour isn't normal. Have you tried repairing the Office installation (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair)?
     
    macropod, May 23, 2018
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.