Word and Excel together make a great team for this operation.

Excel by itself requires a lot of trial and error manipulation of data.

For help on Word mail merge using Excel 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

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033


Gord Dibben Excel MVP


On Wed, 13 Apr 2005 16:29:17 -0700, "Eisenhauer"
wrote:

How do I print address information from multiple cells onto envelope for
mailing