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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim - 24 Nov 2003 21:40 GMT

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?

Reply to this Message

Peter Jamieson - 25 Nov 2003 14:04 GMT

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).

--
Peter Jamieson - Word MVP

> 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?

Reply to this Message