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
Keep numbered list in mail merge the same in each doc
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Keep numbered list in mail merge the same in each doc
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 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
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.
- 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
Hans
-
- 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
Thanks for you confirmation and the advice.
Appreciate it (as always)!
Cheers
Appreciate it (as always)!
Cheers
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Keep numbered list in mail merge the same in each doc
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]
[Fmr MS MVP - Word]
-
- 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
Yep...I did do that.
Cheers :)
Cheers :)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.