Mail merge issue ignored data
Solved
80Brina
Posted messages
2
Status
Membre
-
Anonyme. -
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.
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 réponse
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)
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)
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.
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!
It might have been due to a vertical interval setting between labels...