Merging Labels

Hello, I just posted to thank JoAnn for her suggestion to use Excel. It did
work. I went through the same steps using a Word database as the Excel. I
used the Mail Merge Wizard method for merging a label, didn't even have to go
through creating a blank page the size of one label or multiple copies per
sheet. I previewed one name, but when printed it came out one page with
multiple names. I'll go back through both methods using a Word and Excel
database file and write down the steps. Thanks

"Ron Cohen" wrote:

Those instruction are correct and if followed will give multiple labels with
individual names. Can you repost with a step by step listing of what you
did? Better yet, if you will send me a copy of the .pub file and sample data
I'll go over it and see what step is missing. It's really a simple procedure
to do what you describe. It shouldn't make any difference if you are using a
plain text file, Word database, or one from Excel. All should work. I prefer
Excel files for my data source, but I've also had to use .csv files and they
work just as well.
--
Ron Cohen

"Hague2" wrote in message
...
Hello, I'm back with the same question. How do you get labels to merge
from
a database on one sheet? Not individual names on one sheet each?
The instructions I have received so far does not work:
1. Under setup page size, create a blank page that is the size of one
label.
2. Under Page Setup, select the option "Change Copies per Sheet", Click
on
"Multiple Copies Per Sheet".

I still get multiple labels on one sheet with one name????

Hello again, Well I finally figured out what I was doing wrong. To get the
labels to print individually on each Label you must select PRINT in the Mail
and Catalog Merge Task Pane. NOT Create new Publication. When creating a
new Publication each recipient gets a whole sheet of labels. I was use to
creating a new document in Word's Merge (which works) before printing. Oh
Well, guess you can't do that in Publisher. Thanks again!

"Ron Cohen" wrote:

Those instruction are correct and if followed will give multiple labels with
individual names. Can you repost with a step by step listing of what you
did? Better yet, if you will send me a copy of the .pub file and sample data
I'll go over it and see what step is missing. It's really a simple procedure
to do what you describe. It shouldn't make any difference if you are using a
plain text file, Word database, or one from Excel. All should work. I prefer
Excel files for my data source, but I've also had to use .csv files and they
work just as well.
--
Ron Cohen

"Hague2" wrote in message
...
Hello, I'm back with the same question. How do you get labels to merge
from
a database on one sheet? Not individual names on one sheet each?
The instructions I have received so far does not work:
1. Under setup page size, create a blank page that is the size of one
label.
2. Under Page Setup, select the option "Change Copies per Sheet", Click
on
"Multiple Copies Per Sheet".

I still get multiple labels on one sheet with one name????

Glad to hear it's working for you now.
--
Ron Cohen

"Hague2" wrote in message
...
Hello again, Well I finally figured out what I was doing wrong. To get
the
labels to print individually on each Label you must select PRINT in the
Mail
and Catalog Merge Task Pane. NOT Create new Publication. When creating a
new Publication each recipient gets a whole sheet of labels. I was use to
creating a new document in Word's Merge (which works) before printing. Oh
Well, guess you can't do that in Publisher. Thanks again!

"Ron Cohen" wrote:

Those instruction are correct and if followed will give multiple labels
with
individual names. Can you repost with a step by step listing of what you
did? Better yet, if you will send me a copy of the .pub file and sample
data
I'll go over it and see what step is missing. It's really a simple
procedure
to do what you describe. It shouldn't make any difference if you are
using a
plain text file, Word database, or one from Excel. All should work. I
prefer
Excel files for my data source, but I've also had to use .csv files and
they
work just as well.
--
Ron Cohen

"Hague2" wrote in message
...
Hello, I'm back with the same question. How do you get labels to merge
from
a database on one sheet? Not individual names on one sheet each?
The instructions I have received so far does not work:
1. Under setup page size, create a blank page that is the size of one
label.
2. Under Page Setup, select the option "Change Copies per Sheet",
Click
on
"Multiple Copies Per Sheet".

I still get multiple labels on one sheet with one name????