There is not an easy method to do it in Excel without trial and error
manipulation.
Use Word's mailmerge...........labels and envelopes.
Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.
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 Mon, 29 Mar 2010 08:41:01 -0700, gus
wrote:
mailing address and return address print directly to envelopes or labels from
excel