Word - Mail Merge Labels, subsequent page restarts next record

I'm trying to merge an excel table into word to creating mailing labels and when I do I have no problem merging them until I preview my results. Page 1 will have records 1-30 then on page 2 it will have records 2-31, so it repeats 29 of the records on page 2, so on and so on. Help with this issue please.

Answer
Answer

That is because you are only previewing the results and is you observe the record number in the Preview Results section of the ribbon, you will see that it only advanced one record at a time when you click on the Next Record arrow

If you want to preview all of the labels as they will be printed, you need to expand the Finish & Merge dropdown and select Edit Individual Documents (admittedly a bad name for the function), which will create a new document containing a pages of labels as they will be printed.

Alternatively, you can execute the merge directly to the printer by clicking on the Print Documents item.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

20 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.

 
 

Question Info


Last updated September 3, 2024 Views 5,691 Applies to: