take names and address in excel and move to mailing labels
 

We would like to take names and address that are in an excel document and
move to mailing labels. What steps do we take to do this? I do not work a lot
with the excel program. Any help would be greatly appreciated.

take names and address in excel and move to mailing labels
 

The easiest way to do this is a Data Merge in Word, using the XL
workbook as the data source.

See the "Create labels by using the Data Merge Manager" topic in Word
Help for more.

In article ,
RJKloste wrote:

We would like to take names and address that are in an excel document and
move to mailing labels. What steps do we take to do this? I do not work a lot
with the excel program. Any help would be greatly appreciated.

take names and address in excel and move to mailing labels
 

Excel alone is poorly suited for this task.

Word is much better for labels using Excel as the source for the labels.

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 Wed, 26 Sep 2007 07:00:05 -0700, RJKloste
wrote:

We would like to take names and address that are in an excel document and
move to mailing labels. What steps do we take to do this? I do not work a lot
with the excel program. Any help would be greatly appreciated.

take names and address in excel and move to mailing labels
 

As an FYI, the Avery Dennison folks have a utility that reads an Excel file
and prints labels - the only caveat is that the file can be only one
worksheet. See
http://www.avery.com/us/Main?action=...twarecode=3201

HTH
Steve

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Excel alone is poorly suited for this task.

Word is much better for labels using Excel as the source for the labels.

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 Wed, 26 Sep 2007 07:00:05 -0700, RJKloste
wrote:

We would like to take names and address that are in an excel document and
move to mailing labels. What steps do we take to do this? I do not work a
lot
with the excel program. Any help would be greatly appreciated.