Excel alone is poorly suited for this task.

You can, by trial and error print labels, but Word's mailmerge function is much
easier.

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Tue, 22 May 2007 11:24:01 -0700, mary
wrote:

How do I merge? lables, envelopes and letters