[You've got Mail]

I have a list of addresses that I want to be able to print onto labels for
mailing. I was putting them into the word label format. Is there some
quicker way to get the information from Excel into either Word, or through
Excel onto a 30 count label sheet?

[Suzanne S. Barnhill]

You can use an Excel sheet as a mail merge data source.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"You've got Mail" You've got wrote in
message ...
I have a list of addresses that I want to be able to print onto labels for
mailing. I was putting them into the word label format. Is there some
quicker way to get the information from Excel into either Word, or through
Excel onto a 30 count label sheet?

[Graham Mayor]

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

If you already have (some of) them in Word label format, see
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



You've got Mail wrote:
I have a list of addresses that I want to be able to print onto
labels for mailing. I was putting them into the word label format.
Is there some quicker way to get the information from Excel into
either Word, or through Excel onto a 30 count label sheet?

[Ron Barker[_2_]]

You may find this demo of assistance:

http://office.microsoft.com/en-gb/wo...903941033.aspx

Connect to a data file

Watch the Demo

When you have set up your label main document, you can connect it to the
data file that contains your recipients' names and addresses. This lets you
get the names and addresses from your data file onto your labels. Word can
connect to several different types of data files. This example uses a
Microsoft Office Excel 2003 worksheet.




"Graham Mayor" wrote:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

If you already have (some of) them in Word label format, see
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



You've got Mail wrote:
I have a list of addresses that I want to be able to print onto
labels for mailing. I was putting them into the word label format.
Is there some quicker way to get the information from Excel into
either Word, or through Excel onto a 30 count label sheet?