Multiple pages of labels.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 03 Oct 2003 19:13 GMT

I have a data source of 53 names set up in Excel. I want
to merge those names into labels in Word... however Word
will only create one page of labels and cuts off the rest
of the names. I know I can go in manually and add rows,
but isn't there an option to do that for me?

Reply to this Message

Steve Smallman - 04 Oct 2003 00:03 GMT

Dan,

You may not have selected Entire Sheet as the data source, or your data may
have a blank row. Have you tried merging to a new document and seeing if all
the data turns up?

Steve

> I have a data source of 53 names set up in Excel. I want
> to merge those names into labels in Word... however Word
> will only create one page of labels and cuts off the rest
> of the names. I know I can go in manually and add rows,
> but isn't there an option to do that for me?

Reply to this Message

Peter Jamieson - 04 Oct 2003 08:30 GMT

To print the results are you just using File|Print? If so, you will only see
one page. You need to /perform the merge/ - in Word 2002, you should follow
the instructions in the Mail merge wizard task pane to the end (page 6 of 6
I think). You can either output directly to a printer or to a document which
you cna then print in the usual way.

--
Peter Jamieson
MS Word MVP

Reply to this Message