Getting address list to print labels

K

Katie

I am setting up an address list in columns example First Last Address City/St ZIP phon
I was wondering if anyone had ideas of the best way to print labels as far as importing to where? I have office 200
small business and can't find good instruction as to how to go about setting up an address list to print envelopes and
labels. Any suggestions is appreciated...
 
J

JE McGimpsey

Use the data merge manager in Word to pull from your XL file.

Look at "Create labels by using the Data Merge Manager" in Word Help.
 
D

David McRitchie

I have a web page on Mail Merge strictly from the point of view of an Excel
user forced to use Mail Merge in Word, rather than from someone
used to using Word. In any case you probably won't find one important
piece of information in Word oriented materials. If using Excel as the
database, you must have that worksheet as the first sheet in the workbook,
being the active sheet is not good enough.
Mail Merge, Printing Labels Using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

To print address labels you are expected to use MS Word
to print, and Excel or Access as your database. This article provides information
for Excel usage. Additional items of interest in preparing labels include Avery label numbers, barcode and US zip code information;
also information on reorganizing information from your address book.
 
G

Gord Dibben

Sorry David.

Will remember to include your Mailmerge URL in future postings.

Gord

I have a web page on Mail Merge strictly from the point of view of an Excel
user forced to use Mail Merge in Word, rather than from someone
used to using Word. In any case you probably won't find one important
piece of information in Word oriented materials. If using Excel as the
database, you must have that worksheet as the first sheet in the workbook,
being the active sheet is not good enough.
Mail Merge, Printing Labels Using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

To print address labels you are expected to use MS Word
to print, and Excel or Access as your database. This article provides information
for Excel usage. Additional items of interest in preparing labels include Avery label numbers, barcode and US zip code information;
also information on reorganizing information from your address book.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Gord Dibben said:
In addition to John's post.

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Gord Dibben Excel MVP
Click to expand...
Click to expand...
 
D

David McRitchie

There's a lot of links on my Mail Merge page, you could try to include
them too <grin>. If not doing labels, other links are probably
better, except for failing to mention the first worksheet tab.
 
B

Brian

I often do this myself from my club membership spreadsheet. Use word
to do this merge.
First in Excel, name the range (includiing column headings) in which
the data resides. Then the information can be on any worksheet, not
just sheet 1.
With the mail merge function in Word, select the worksheet and named
range as the data source.
 
D

David McRitchie

Hi Katie,
I've only had limited success with a named range, but maybe I've
done it wrong. For me I'd stick with using the first worksheet.
But would like to hear if you have 100% success with named ranges.
Since I end up making changes to some of the things, I'm also
likely to make up additional lists with different values in some columns.

I would move the phone number to the left on your spreadsheet,
then the last name (sorted), and then the first name, address, ..

You can move the column by holding the SHIFT key and grabbing the
border below the column headers and then dragging.

I would make phone numbers text and right aligned, unless you
have extensions. I would make zip codes text and the default
left alignment.

This way you look at the lastname and you can quickly see the
phone number or the address. I expect that you wouild most
frequently look at the phone number anyway, if not it is shorter
and of consistent width.

My page on Mail Merge is specifically for printing labels
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
You can use Data, Filter to create a filtered list and only
those that make it through the filter will be seen by Word,
or for copy and pasting for that matter.
 
G

Gord Dibben

David

I also had problems with the "named range" before I installed Excel 2002.

Using the Mail Merge Wizard is a breeze and all sheets and named ranges are
available for choice in the dialog.

Gord Dibben Excel MVP

Hi Katie,
I've only had limited success with a named range, but maybe I've
done it wrong. For me I'd stick with using the first worksheet.
But would like to hear if you have 100% success with named ranges.
Since I end up making changes to some of the things, I'm also
likely to make up additional lists with different values in some columns.

I would move the phone number to the left on your spreadsheet,
then the last name (sorted), and then the first name, address, ..

You can move the column by holding the SHIFT key and grabbing the
border below the column headers and then dragging.

I would make phone numbers text and right aligned, unless you
have extensions. I would make zip codes text and the default
left alignment.

This way you look at the lastname and you can quickly see the
phone number or the address. I expect that you wouild most
frequently look at the phone number anyway, if not it is shorter
and of consistent width.

My page on Mail Merge is specifically for printing labels
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
You can use Data, Filter to create a filtered list and only
those that make it through the filter will be seen by Word,
or for copy and pasting for that matter.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Brian said:
I often do this myself from my club membership spreadsheet. Use word
to do this merge.
First in Excel, name the range (includiing column headings) in which
the data resides. Then the information can be on any worksheet, not
just sheet 1.
With the mail merge function in Word, select the worksheet and named
range as the data source.
Click to expand...
Click to expand...
 
Top