View original (French)

Mail merge issue ignored data

Solved
80Brina Posted messages 2 Status Member -  
 Anonyme. -
Hello,
I am encountering an issue for which I currently have no solution.
I hope you can help me resolve this problem.

I am doing a mail merge to create mailing labels, around 6000 recipients.
I am creating my sheet on Word, using an existing list, inserting my fields and the "Next Record" rule. I format it, then finish and merge. That’s when the drama happens.
I realize that some recipients are missing from the produced document. However, when I click on "Edit Recipient List", they are indeed present, and in my data table on Excel, I notice no anomalies.

Is this a problem you have encountered before?

Thank you for your attention.

1 answer

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    Mailing problems occur sometimes; however, they come in different types and arise from various causes.
    So give us some details about "some recipients are nonexistent in the produced document": do you get unfilled (blank) labels in the middle of a printed sheet, or at the end? Is the first label of sheet 3 not the one that follows the last one of sheet 2? Or is it something else entirely?

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    2
    1. 80Brina Posted messages 2 Status Member 2
       
      Hello Raymond, thank you for your interest.
      Indeed, upon rereading, I lack precision.

      The mail merge produces a 300-page document of address labels. However, not all recipients appear. This means that there should logically be a recipient between the last recipient present on the page (bottom right) and the first recipient on the next page (top left). They do not appear at all.

      If I take the example that my recipients are letters, it looks like this:

      A
      B
      C
      D
      E
      G
      H
      I
      H
      J
      K
      M

      F and L, which should follow, are ignored.

      EDIT: This morning, by removing the "Next Record" rule from my Word database at the level of my last label, the problem is resolved.
      2
      1. Anonyme. > 80Brina Posted messages 2 Status Member
         

        4 years later, the answer is still relevant!

        After using the "Update Labels" command, CLEAR the "Next Record" field that is located on the last label of the page (Word always considers that a new page = a new record).

        3 hours of struggle before coming across this post.

        THANK YOU!

        0
    2. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      So much the better!
      It might have been due to a vertical interval setting between labels...
      0