Create Labels Using Excel Data

What is a Mail Merge?

Mail Merge is a common term you often hear in Office environments but they can be useful for home users as well. It is used to create a set of documents, envelopes, labels, and so on that is basically the same but need to contain certain unique elements, such as the address and greeting line. So when might one want to use a mail merge? Two examples include:

  • When you need to create labels or envelopes and the mailing address needs to be different on each one.

  • A set of faxes or e-mails that contain the same basic information but also need to contain some piece of unique information.


By using a mail merge, all you have to do is create one fax, envelope, e-mail message, etc. and use placeholders where you want the unique information to be added.

When it comes to creating labels, Microsoft Office makes it relatively simple. If you have the data stored in another file, such as a spreadsheet, you can perform a mail merge to have the data imported into your labels. The remainder of this article will outline the steps that must be completed in order to create labels in Word using data in an Excel spreadsheet.

Before you begin using the Mail Merge wizard, you need to make a small configuration change within Word. From the Tools menu, click Options. Select the General tab and place a check beside the Confirm conversion at open option. With that step completed, you are ready to create your labels.

You can start the mail merge process in Word 2002 using the steps listed below:

  1. Open Word.

  2. From the Tools menu, point to Letters and Mailings, and click Mail Merge Wizard. If you are working in Word 2003, click Mail Merge.
  3. Under Select document type, click Labels. This option is used for creating address labels.
  4. Click Next: Starting document.
  5. Under Select starting document, select Change document layout.
  6. Click Label options. Select the paper type that you will be using such as Avery Standard 5160 Address. Click OK.
  7. Click Next: Select recipients.
  8. Under Select recipients, click Use an existing list. This option assumes that you are using address information stored in another file or database.
  9. Click Browse to locate your spreadsheet containing address information. Click Open.
  10. Select the table containing the address information and click OK.
  11. Place a check beside the recipients you want included in the mail merge. Click OK.
  12. Click Next: Arrange your labels.
  13. Click More items.
  14. From the Insert Merge Field dialog box, select the fields you want to include in the mail merge. Click Insert. These should be the fields that contain the recipients’ names and addresses. Close the Insert Merge Field dialog box.
  15. Format the first label as you want it to appear when it is printed. Click Update all labels.
  16. Click Next: Preview your labels.
  17. Click Next: Complete the merge.
  18. If you are satisfied with the appearance of the labels, click Print.

Your labels will now be printed. Each label should contain a different address based on the address information that was in your Excel file.

Article Written by

  • deb algadi

    I guess I am just drawing a blank. I am using 2007 Office and cannot get the constant and variable information on the same label!!! I have been trying for 3 days! Any ideas to simplify this for my brain?

    I have a database in Excel that actually it has now changed to access it appears on its’ own after playing around in labels.

    I need to type in titles like “Windows Password:” that needs to be the same on every document including our school logo, school name, school address, etc; then I need variable info to be entered from a db, such as their personal pwords, names, email address, etc; etc; How do I get the two seperate created & to stay/copy over and in the same labels and in order and then enter my variables and not have them wipe out my constant settings like the school name, etc;
    Thanks for any light you can shed for me. Alot of terminology seems the same from 2002 to 2007 but I still am at a loss!

  • http://www.aboonbooks.com/ebook.php self-publishing children’s books

    Thanks so much for this step-by-step description. Here it is two years after you posted this and I followed the instructions today. Yours was the third or fourth set of instructions that I found on this topic and the only one that actually worked! I never would have figured it out on my own or with Microsoft’s help info. You were a real lifesaver!

  • leticia

    please advise on how to create a multiple page document for labels – I am trying to set up a company database for client’s mailings (such as christmas cards, press releases). we have about 500 labels that need to be created (between clients and suppliers).
    Thanks in advance.

  • Shani Overfelt

    Thank you so much for your step by step instructions. I needed to import address from an excel spreadsheet and the info on Microsoft’s page was not helping. I had no problem creating letters, envelopes and labels. Thanks again!!!!

  • John

    thank you for your help, this was a useful article and much appreciated!

  • megan

    Thanks for the help! this article is just what i needed! very good explanation!

  • http://west-penwith.org.uk/blog/ Rick

    Great – the only set of instructions that we found that worked for Office 2003. We only ever do it once a year at Christmas and we never remember by the next year.

  • Oswald

    Thank you for your very precise, simple and easy to implement steps. I was able to print my labels in about five minutes

    Thanks again

    Oswald

  • Liz

    Thank you for your easy, step by step instructions. They are a thing of beauty.

  • Justin Orr

    pre-wedding life saver! Thanks

  • Tessa

    I still need help. Got all the way to browse and I will not pull up my spreadsheet. Gives me a message to confirm data source of OLE DB Database and when I clck OK it does nothing. Can you help?