Can only print one page of labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

otium - 09 Mar 2004 15:39 GMT

I have set up an Excel spreadsheet to print labels for batch controlle
stock receipts. It is designed so that the user only has to enter th
purchase order number and the sheet is automatically populated wit
data for producing the required labels.

This sheet is the source for producing labels in a Word2000 document.

The way it works is...
Enter order number in Excel which populates data
Open the Word document (data is there)
Print labels
Close Word document
Repeat above for each order number.

It works brilliantly, with one problem.

When you print the labels it only prints the first page.

The only way I can find around this is to go through the Mail Merg
wizard each time, but I don't see why that should be necessary

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 10 Mar 2004 12:58 GMT

From the View menu, select Toolbars and check the Mail merge item. That
will cause the mailmerge toolbar to be displayed and it has all of the
buttons that you will require for performing a mailmerge from Go to Whoa
without the stupid wizard. In particular you will want to use the button
for merging to the printer.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>
> I have set up an Excel spreadsheet to print labels for batch controlled
[quoted text clipped - 20 lines]
> ------------------------------------------------
> ~~ Message posted from http://www.WordForums.com/

Reply to this Message