How do I print mailing labels from my spreadsheet data?

R

Rod

Hi all,

I am running Excel 2000. I have an Excel file that is no
more than names and addresses, arranged as Names under
column A, Address under column B. There are 861 of these
entries and I need to find out how to get these adresses
printed as labels. I have the full Office suite, so the
other apps like Word are present and I use Outlook as my
mail client. Please Help! :)

Thank You.
 
A

Ann Scharpf

Rod,

Go into Word and use the mail merge.

Tools > Envelopes & Labels

Go into the Options button and select the correct Avery
label layout. (Go by dimensions if you're not using Avery
labels.)

Click the New Document button.

Tools > Mail merge. Click the Create button in the Main
Document section of the dialog.

Select "Mailing Labels" and "Active Window"

In the top left cell of the table of labels, select "Get
Data" and "Open Data Source". Browse to your Excel file.
Double-click on it.

Click the Insert Merge Field button to view the list of
your field names. Insert the fields with the proper
spacing, returns & punctuation. Copy the whole set of
cell names.

For each remaining cell, start with the "Next Record"
field (from the Insert Word Fields button). Paste the
cell names that you copied.

HTH

Ann Scharpf
 
D

David McRitchie

One addition to Ann's instructions. You should drag the worksheet
to the beginning of the workbook so it is the first workbook. Word
will not recognize your worksheet merely by being selected.
 
G

Gord Dibben

David

Info only.

No longer necessary in versions 2002 and 2003.

Word provides a menu to choose which worksheet you want once you have pointed
to the workbook.

Gord Dibben Excel MVP
 
Top