You might not receive an email informing you that there is a new reply in a thread you are following. We are working on fixing this as fast as possible. Please make sure to periodically check the conversation to see if there are any updates.
October 31, 2024
Please note, the notification system in the Community is partially broken
You might not receive an email informing you that there is a new reply in a thread you are following. We are working on fixing this as fast as possible. Please make sure to periodically check the conversation to see if there are any updates.
October 14, 2024
Word Top Contributors:
Mail Merge Document Dropping Record at Page Breaks
Report abuse
Thank you.
Reported content has been submitted
If you are merging several 'documents' to a page then you should set up a single document and change the merge document type to Directory/Catalog.
If you are merging one 'document' per page, then you should set this up as a Letter merge document.
Neither requires a Next Record field.
If you are trying to create a 'many to one' merge document i.e. data from several records relating to a key field, then Word cannot readily do this. Instead see http://www.gmayor.com/ManyToOne.htm
For more Word tips and downloads visit my web site
https://www.gmayor.com/Word_pages.htm
Report abuse
Thank you.
Reported content has been submitted
7 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Trying to use a Microsoft Excel document with almost 1000 records, into a report by creating my own label format (one label per line). Each page break I loose a record.
I do not feel good about adding a 3rd party add in
did anyone actually get this to work without loosing records?
Report abuse
Thank you.
Reported content has been submitted
5 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
If you have a «Next Record» or { Next } field before the mergefields in the first label on the sheet, delete it. Or, if you have those fields after the mergefields in each label on the sheet, and you have one after the mergefields in the last label on the sheet, delete it.
If you cannot sort it out by either of the above, send me a copy of the mail merge main document and I will look at it.
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy
Report abuse
Thank you.
Reported content has been submitted
35 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi I have a similar problem when merging fields into a letter template. I drop TWO records when moving to the next page. I do not use next record or next BUT do use nested NEXTIF . Does anyone know if there is a similar issue with NEXTIF ? Is there workaround or FIX ?
Rgds eddie george
Report abuse
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
What's the purpose of the NEXTIF?
What is it that you are trying to do?
If you send me a copy of the mail merge main document and the data source, referencing this thread in the covering email message, I will investigate the issue.
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy
Report abuse
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated September 30, 2024 Views 4,260 Applies to: