Labels using Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beverly - 20 Nov 2003 21:37 GMT

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.

Reply to this Message

Peter Jamieson - 21 Nov 2003 02:32 GMT

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).

--
Peter Jamieson - Word MVP

> Help!! I am trying to create labels using a mailing list
> I have produced in Excel. When I try to create the
[quoted text clipped - 3 lines]
> Word (not Excel). Also, when I thought I had it correct
> & asked for the merge, all I got was a blank label page.

Reply to this Message