After Merging and Saving, Saved Document only saves 1 page. Where did it go?

[Kim]

Whenever I run a mail merge with excel and print it
immediately, all the pages print out. Then I save it and
open it later to print another set of labels, it only
prints one sheet. The rest of the document is gone. How do
I fix it or do I have to rerun the list everytime I want
to print it?

 

[Peter Jamieson]

When you merge to printer, the mail merge main document you are merging does
not change (well, it may change in ways that will cause Word to ask you to
save it, but it does not turn into a document with all the labels in it). To
save the merged labels, you need to merge to a new document, then save that
document. (In Word XP and later the merge to a new document option would be
called "Edit individual labels" and is in Step 6 of the mail merge wizard).