Keep numbered list in mail merge the same in each doc

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Keep numbered list in mail merge the same in each doc

Post by Rudi »

Here is a challenge I stumbled upon in Word 2010, and was wondering if anyone has any better answer to resolve this...

I am doing a mail merge document which has a numbered list 1-8. When I merge the document the first time the list in each document is 1-8. However, if I go back into the document after I have saved it and closed it the numbers change in each document. The second document will be 9-16, the third document will be 17-24 and on and on and on. Not even the section breaks that the mail merge adds to the end of each document prevents the bullet list from changing after save and re-open.

I obviously can change the bullet numbers to plain number to solve the issue...I even found a macro that can do this for me (as below)

Sub ConvertToPlainNumbers()
ActiveDocument.ConvertNumbersToText
End Sub

However...
Is this a bug in the program?
Is there a better solution than converting the bullet numbers to plain text?
Any ideas?

TX
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Keep numbered list in mail merge the same in each doc

Post by HansV »

The only workarounds are
- Converting the numbering to plain text, using the macro that you mentioned (*)
and
- In the merged document, right-click the first number in each letter, and select Restart at 1 from the context menu.

(*) You don't even need to create a macro, you can run

ActiveDocument.ConvertNumbersToText

from the Immediate window.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Keep numbered list in mail merge the same in each doc

Post by Rudi »

Thanks for you confirmation and the advice.
Appreciate it (as always)!

Cheers
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
macropod
4StarLounger
Posts: 508
Joined: 17 Dec 2010, 03:14

Re: Keep numbered list in mail merge the same in each doc

Post by macropod »

I'd suggest converting the numbers to text in the mailmerge main document. Then you won't need to do anything with the outputs documents afterwards.
Paul Edstein
[Fmr MS MVP - Word]

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Keep numbered list in mail merge the same in each doc

Post by Rudi »

Yep...I did do that.
Cheers :)
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.