Excel Address Labels?

June 4, 2008 11:43 AM

Excel filter:: Making mailing labels out of an excel spreadsheet?

So I'm looking for a quick way to print a batch of labels from an Excel Spreadsheet... The addresses are broken into columns, so the name is in column A, the street address is in column B, and the city and zip is in column B... Thoughts? I've looked at Word's (2003) "envelopes and labels" stuff, but the only thing that it offers there is to import from Outlook's Address Book.... Any help would be appreciated!

posted by ThomThomThomThom to computers & internet (4 comments total)

This will be very simple with a mail merge--have you done one before? I no longer have Word 2003, so I can''t tell you which menu it's in. The key is that you are actually creating labels in Word, with the data being extracted from Excel.

Also, if you are using Avery brand labels there is likely a numbered template indicated on the packaging that you can use in Word to make sure it is all the right size.
posted by Ignatius J. Reilly at 11:49 AM on June 4, 2008

From my 2000 version of Office:

Use Microsoft Excel data as a mailing list in Word
You can use this procedure to create form letters, mailing labels, and other merged documents by merging a list of data with a Word document. You must create the list before you perform this procedure. The list must include column labels and contain no blank rows. For information about creating a list, click .

Save and close the workbook that contains the list you want to merge with a document in Word.


Switch to Microsoft Word.


Open the Word main document that contains the standard text for the form letter or other document you want to merge with the list.
If you're starting a new document or printing mailing labels or envelopes, click New to open a new blank document.

On the Tools menu in Word, click Mail Merge.


Click Create, and select the type of document.


Click Get Data, and then click Open Data Source.


In the Open Data Source dialog box, open the folder that contains your Microsoft Excel workbook.


In the Files of type box, click MS Excel Worksheets (*.xls).


Double-click the workbook that contains your data.


In the Microsoft Excel dialog box, select the named range, or type the cell references that identify the data you want to use, and then click OK.


When Word displays a message, click Edit Main Document or Set Up Main Document.


If you're creating a form letter, use the Insert Merge Field list on the Mail Merge toolbar to insert merge fields within the standard text. When you finish, click Mail Merge Helper on the Mail Merge toolbar.
If you're printing address labels or envelopes, select the printer and the size of address labels or envelopes. Then insert the merge fields in the Create Labels or Envelope Address dialog box.

In the Mail Merge Helper dialog box, click Merge, and then select the options you want.
Tips

For more information about creating merged documents in Word, use the Office Assistant or Help index in Word to search for "mail merge."


To display only the rows of data you want to merge before you select the list in Word, you can first filter the list in Microsoft Excel. When you select a filtered list as a data source in Word, select _FilterDatabase in the Microsoft Excel dialog box. For information about filtering a list, click
posted by TedW at 12:02 PM on June 4, 2008 [1 favorite]

What Ted said plus just remember to put spaces (returns) in between your fields once you've inserted them all.
posted by b33j at 2:47 PM on June 4, 2008

Mail merge instructions for Word 2003. (Different from the Word 2000 instructions above.)
posted by gum at 3:13 PM on June 4, 2008