We help IT Professionals succeed at work.

Mail Merge//Numbering Issue - MS Word

SJATechsupport
SJATechsupport used Ask the Experts™
on
Hi all --

Having an interesting issue.

I have a user that has created a mail merge document. In the document are three fields pulled from a spreadsheet (first, last, amount). The document also has a numbered list set up (i.e. - I, II, III, IV, V...)

Everything works in the merge, and when you merge the documents and 'edit individual documents', everything comes out okay (read: each "individual document" (which is really just a separate page in the merged document) has the correct numerals). The problem arises when you change ANYTHING in the merged document, save it, close it, and reopen it. Once it has been reopened, the numbering changes from it being I, II, III, IV, V on every page to being I, II, III, IV, V on the first page, VI, VII, VIII, IX, X on the second, etc etc for the rest of the documents.

I have tried recreating the document and spreadsheet to no avail. Any ideas?!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

In the first paragraph of the numbered list in the merge file (the file with the field codes), format the settings of the list to start the numbering at 1 again. I'm not in front of Word right now but I will post step by step instructions in a couple of hours unless someone else chimes in.

Cheers, teylyn
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

it seems that my cunning plan does not work.

Apparently, when saving the merged file, the numbering settings revert to one big list instead of several lists that start with new numbering on each page.

You can manually edit each page, right click the first numbered item, select Numbering > Set  Numbering Value and enter an i as the new starting value.

But that's probably not what you want to do.

So, is there a need to use the merge to a document to preview? Could you just merge straight to the printer?

Author

Commented:
That was my thought, but apparently the user needs to edit the document post-merge.
I had found out that I can reset the numbering manually (I can also manually type I, II, III..., but that's not ideal either).
Thanks for your help thought!
Most Valuable Expert 2011
Awarded 2010

Commented:
Well, if they need to edit the document post-merge, they may as well click through to edit the starting number for the list.

One more step, I know.

But then, why do they need to edit the post-merge in the first place? What exactly is not working in the merge that they need to manually adjust?

If that can be fixed, then the numbering doesn't have to be.

Get what I'm driving at?

Author

Commented:
Oh, I definitely understand. Still though, seems like something that I should be able to fix. The user has told me that when she used Office 2003 she was able to do this without the numbering changing, but I can't for the life of me find any option to toggle...
I'll just go and tell her to make sure all of her merge fields are correct prior to merging, but leave this thread open in case someone else has an idea..
Most Valuable Expert 2011
Awarded 2010
Commented:
I'll go have a try with Word 2003 and consult with some other Word gurus, No promises, but I'll do my best to find out why/how this can be done in 2010.

cheers,