Printing multiple labels based on contents of cell
What is actually to be printed on the labels? The name of the product?
What is the data source?
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"TThunder" wrote in message
...
I'm using Office 2003 --
I have an order form with the purchaser's name in column A and products to
be ordered in columns B-Z. Most cells are empty, but if someone orders a
product, the number of items ordered for each product is in the
corresponding
cell.
Example:
Customer Jelly Jam Peanuts
John Doe 2 1
Jane Doe 3 1
I would like to print labels with the customer's name and product, and
print
as many labels as there are products ordered, for example, 2 labels for
John
Doe/Jelly, 1 label for John Doe/Jam, 3 labels for Jane Doe/Jam, 1 label
for
Jane Doe/Peanuts, etc.
How can I do this? Thanks -- T.
|