Mail merge labels for hanging file folders

I am trying to use the Word mail wizard for my mail list I created in Excel. When I choose label Avery US 5766 and format my first label everything looks right. Then when I click the update all labels, the data in generated in the middle column also that isn't actually a label. How do I keep this from happening? Also, I wanted all of the labels to have a split cell like in the 1st label shown, but when I went to update all labels, none of the other labels kept the split cell format. Is there anything I can do? I have over 400 unique records to complete and I do not want to have to do them all individually if I don't have to.

Answer
Answer

I cannot replicate that issue here.

Image

Try starting again.  Or, assuming that the cells in the third column are populated correctly, with the «Next Record» field before them, just delete the errant entries in the middle column and then execute the merge.

However, if you cannot sort it out, send me a copy of the mail merge main document (so that I can see what merge fields you are using) and I will send one back to you that should work OK

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com

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 April 14, 2025 Views 168 Applies to: