Duplicate Mail Merge Record Every Time

Discussion in 'Word' started by bigtunelover, Nov 23, 2018.

  1. bigtunelover

    bigtunelover

    Joined:
    Nov 23, 2018
    Messages:
    3
    Likes Received:
    0
    Hi There,

    I am using Word and Excel 2013. For a long time I had no issues using mail merge daily to create labels. At one point, I started to get an extra record and now it is happening every time.

    In my first row, the first record prints out an extra time and then the rest of the sheet of labels is fine.

    Its driving me crazy as occasionally I mislabel things that I am doing in sequence.

    The first label does not have "next record" and the rest of the cells in the table do.

    Please help!

    Les
     
    bigtunelover, Nov 23, 2018
    #1
    1. Advertisements

  2. bigtunelover

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    403
    Likes Received:
    35
    Your description suggests there's a duplicate record in the data source.
     
    macropod, Nov 23, 2018
    #2
    1. Advertisements

  3. bigtunelover

    bigtunelover

    Joined:
    Nov 23, 2018
    Messages:
    3
    Likes Received:
    0
    Nope. I wish it were that simple. It's not the source.
     
    bigtunelover, Nov 27, 2018
    #3
  4. bigtunelover

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    403
    Likes Received:
    35
    So where does the duplicate record appear?
     
    macropod, Nov 28, 2018
    #4
  5. bigtunelover

    bigtunelover

    Joined:
    Nov 23, 2018
    Messages:
    3
    Likes Received:
    0
    The first line on the source, gets created twice. The first and second labels are identical.
     
    bigtunelover, Nov 29, 2018
    #5
  6. bigtunelover

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    403
    Likes Received:
    35
    Try clicking 'Update Labels', then re-running the merge.
     
    macropod, Nov 30, 2018
    #6
    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.
Similar Threads
There are no similar threads yet.
Loading...