Thanks Paul. Ran mail merge again, same problem. Guess I might have to try a reinstall?

A reinstall rarely fixes anything a repair doesn't. Your problems still suggest to me a rogue 3rd-party addin. There was at one stage a bad Skype update that played havoc with copying & pasting formatted content, which resulted in only plain text being pasted, and this sounds very much like that kind of thing. It's also possible your document template is corrupt - and reinstalling won't fix that.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tried it again after running diagnostics, still having same problem. Guess my only other option is a complete reinstall? And then I'd need to copy back normal.dot to retrieve settings, macros, etc?

As I've already said, it's unlikely a reinstall of Office would resolve anything - it rarely fixes anything a repair doesn't. IMHO the most likely culprit is an as-yet unidentified 3rd-party addin. Reinstalling Office wouldn't fix that, either.

The other possibility (as I also mentioned) is that your document template is corrupt - and reinstalling won't fix that, either. You could try closing Word & renaming your Normal.dotm template. Word will create a new one when it re-starts. If the problem goes away, then it has something to do with the original version of that template.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Oops, thx Paul, didn't realize the thread had gone to page 2 so I hadn't seen your original post about reinstalls.

I don't see any third-party add-ins. Happy to list everything that appears under add-ins if that would help.

I renamed normal.dotm, Word created new file, went thru mailing list steps again, same problem. Anything else I might try? Thx!

Is this a Tablet PC (or a PC with tablet technology)? There has been a long standing issue with label propagation and Tablet PCs - see https://support.microsoft.com/kb/898630. For a workaround see http://www.gmayor.com/tabletpc_propagate.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks Graham, this is probably the cause. I'm using a Lenovo Yoga 2 laptop, which can convert to tablet mode. Tried setting up a new macro using your second link, whcih somehow led to losing all my other macros. Restored with a previous version of normal.dot, but keep getting security message when I try to run any macros (no matter what setting I use in the Trust center). This is getting discouraging...

Ok, I'm back, restored the macros. Your macro doesn't seem to work (pops up MS VB box with red X in the middle), must be doing something wrong? Using the onscreen keyboard as noted in your first link seems to do it. The only problem now is that the whole process produces only the first page (30 labels) of the 150 records in the spreadsheet. Not sure how to produce all 5 pages at the same time.

Graham - I sent you an email from your site, without realizing you're the same person here, sorry! Also, I take it MS has never come up with a fix for this problem? Any idea whether they're actually working on it? Wouldn't want to estimate the number of hours I've spent on this, when it turns out to be a MS bug. grrrr

I have replied to your e-mail.

I have retested the macro this morning in Word 2007 and it still works as stated. It replaces the in-built propagation tool, so that there is no need to 'run' it separately. It runs when you click Update Labels. If you are getting macro errors, there must be something amiss with the way you have copied the macro to the VBA editor.

If you click Debug > Compile Normal, what does the editor report?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks Graham. Changed the name back as requested, then clicked Macros > MailMergePropagateLabel > Edit > Debug > Compile Normal, didn't seem like anything happened. Clicked Debug again, now Compile Normal is grayed out.

OK. That's reassuring. Try it now with a Label Merge document with some data in the first cell. It should put the data in all the cells and add any missing Next record fields.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks Graham. Before I try that again, still trying to figure out why I'm getting only the first page of labels. There are 99 rows of data on sheet1 of the spreadsheet, so there should be 3+ pages of labels @ 30 per page. But the mail merge process is producing only 30 at a time.