Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I make address labels with MS Word 2002? I would like to import my address book from Outlook and print a bunch of address labels to put on envelopes (one label per address). I know how to make the layout for the stickers, but it's been several years since I've done this. Unfortunately, I don't remember how I did it last time!

share|improve this question
up vote 2 down vote accepted

You'd do a mail merge into MS Word from Outlook.

Full instructions can be found here

Outlook presents a number of printing problems that users can find difficult to resolve. For example, printouts of custom forms don't look anything like what you see on the screen: Fields appear in a predetermined order that you can't change, and any custom fields are listed at the end in alphabetical order. The best custom form-printing solution I've found is to program an Outlook form to push its data into the fields in a Microsoft Word template.

Outlook printing dilemmas aren't limited to custom forms. When people who have amassed many lines of notes in individual Contact items try to print multiple contacts from the Address Cards view, they find that Outlook truncates those notes. The problem is that printing from any folder view is strictly a matter of what you see is what you get. Folder views never show the full text of the Notes or Message field, only a maximum of about 250 characters, so you can't use a folder view to print those notes in their entirety.

The solution built into Outlook is to use the Memo print style to print individual contacts. This technique doesn't produce a neat listing that looks like the Address Cards view, but the Print dialog box displays a "Start each item on a new page" option that you can leave unselected to conserve a little paper. Outlook's rules determine which fields are printed—typically, all those in which you've entered data.

When you need a compact printout of just a few key fields plus your notes from the Contacts folder, the solution-–just as with custom forms-–is to use Word. Unlike the custom forms solution, though, you don't need to write any programming code. Instead, you can use Outlook's integration with Word's Mail Merge feature. You need Outlook 2002 or Outlook 2000 to make this method work.

The trick is to start the merge from Outlook, not Word. Make sure the Contacts folder view is displaying the fields you want to print in the order you want them printed. Then, choose Tools, Mail Merge. Under "Fields to merge," choose "Contact fields in current view." Under "Document type," choose Catalog. Click OK to start Word and launch the merge process.

After Word starts, use the Insert Merge Fields button on the toolbar to add a placeholder for each Contact field to the merge document. (In Outlook 2002, that button is to the left of the Insert Word Field button.) You can format the merge document any way you like and insert additional text as needed. For example, you might highlight the FullName field with bold text or shading or preface other merge fields with labels such as "Email:" and "Notes:" to duplicate the look of the Address Cards view.

Be sure to include one or two blank lines after all the merge fields to provide separation between entries. If you want the printout to duplicate the multiple-column look of the Address Cards view, choose Format, Columns to select the number of columns. You might want to use File, Page Setup to switch the page from portrait to landscape orientation if you plan to display more than two columns.

After you finish editing the merge document, click the Merge to New Document button and choose to merge From 1 To 10 as a test. Examine the resulting document, then go back to your merge document, make any necessary changes, and test again. When you're satisfied, click the Merge to New Document button one more time, and choose All. Depending on the number of contacts and the complexity of your layout, Word might take a few seconds or a few minutes to perform the merge. After Word completes the merge, you can do additional formatting and cleanup before printing out your customized contacts list.

The one thing you lose with this method is any formatting in the notes section (printing in Outlook's Memo style preserves this formatting). That loss is a small price to pay, I think, for the much greater control that you gain over the layout.

share|improve this answer
I was really looking for something more like step-by-step instructions. – Jim Fell Dec 6 '10 at 22:07
Have you read my answer? Read from paragraph 7. Thats step by step instructions – Joe Taylor Dec 7 '10 at 10:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .