Labels using Excel

B

Beverly

Help!! I am trying to create labels using a mailing list
I have produced in Excel. When I try to create the
address block, I don't know how to make the info go on to
the next line. I know how to set up the fields in the
old MS Word but I've always used info that was already in
Word (not Excel). Also, when I thought I had it correct
& asked for the merge, all I got was a blank label page.
 
P

Peter Jamieson

You can still use the individual fields the same way you used to (more or
less).

ADDRESSBLOCK relies on Word being able to find recognisable field names
(Street, City etc.) in the data source. If those names don't exist, you have
to use Word's Match fields facility to tell Word what fields make up the
address.
When I try to create the
address block, I don't know how to make the info go on to
the next line.

Not sure what you mean by this.
Also, when I thought I had it correct
& asked for the merge, all I got was a blank label page.

If you had problems with the ADDRESSBLOCK, this is understandable. But did
you copy the content of the first label cell to all the other cells?
(There's a propagate label function in Word XP that can help with this).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top