creating labels in excel

[Common]

I am a totally newbie for computers & wanted to know how to create label in Excel....???? Actually one of my friend asked me how to do that & i replied him i will show him tomorrow.... But now i tried finding it but was not able to find it does anyone know how is it possible???? I just forgot to say i am using office 2007...

[Eric B]

Configure the labels for the mail merge in Word :

You configure the layout of the labels just once, for all the labels in the mail merge. In a mail merge, the document that you configure for the layout is referred to as the main document for labels. In this document, you can also configure any content that you want repeated on each label, such as a company logo or your return address on shipping labels.

Chances are that you already have a package of label sheets from one of the label sheet suppliers such as Avery, AOne, or Formtec. Each label sheet is a certain size and contains a certain number of labels with specific dimensions.

To configure the label main document, you match its dimensions with the dimensions of the labels on the worksheets that you plan to use.

1. Start Word.
   
   • By default, a blank document opens. Leave it open. If you close it, the commands in the next step are not available.
   
   
   
2. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge.
   
   
3. Click Labels.
   
   
4. In the Label Options dialog box, you have several choices to make.
   
   
   • The type of printer that you are using to print the labels.
   • The supplier that produced your label sheets.
   • The number that corresponds to the product number listed on your package of label sheets.
   • The product number for my label sheets does not match any one of the choices in the Label Options dialog box.
   
   
   
5. After you select the label options that you want, click OK.

Word creates a document that uses a table to lay out the labels. If you do not see lines separating the labels in the layout, click the Layout tab under Table Tools, and then in the Table group, click View Gridlines.

Interrupt and resume a mail merge :

If you need to interrupt your work on a mail merge, you can save the label main document as you would any other document and resume the merge later. Word retains the data source and field information in the document that you save. If you were using the Mail Merge task pane when you stopped working on the merge, Word returns to your place in the task pane when you resume the merge.

1. When you are ready to resume the merge, open the label main document that you saved.
   
   • Word displays a message box that asks you to confirm that you want to open the document and run an SQL command.
   
   
   
2. Click Yes to connect to your Excel source file and retrieve your address list.
   
   • The text of your label main document, along with any fields that you inserted, appears.
   
   
   
3. Click the Mailings tab, and resume your work.

[johnson22]

Create Data Labels :

1. Open your Excel program and create a new worksheet.
   
   
2. Set up the data labels in list format. Type "Surname" in column A and row 1 (A1). Type "Name" in cell B1. Type "Street" in cell C1. Type "City" in cell D1. Type "State" in cell E1. Type "Zip" in cell F1.
   
   
3. Populate all of the data labels for each person you are mailing correspondence to. For example, under "Name" type the names of all people you are sending material to. Insert a space between the person's first and last names.
   
   
4. Save the file (go to "File" menu and select "Save") after you finish populating all of the fields.

Open Mail Merge Wizard

1. Open Microsoft Word.
   
   
2. Click "Tools," "Letters and Mailings" and then "Mail Merge Wizard."
   
   
3. Click "Labels" under "Select document type."

Choose Label Type :

1. Click "Next: Starting document" in the bottom right corner of the screen.
   
   
2. Click "Label Options" and select the type of label you will print. For example, you could select Avery address labels, type 5162.
   
   
3. Click "OK" after you select the label type.

Select Recipients :

1. Click "Next: Select recipients" in the bottom right corner of the screen. At the top of the screen under "Use an existing list" click "Browse."
   
   
2. Find your Excel spreadsheet that includes the mailing data label fields on your computer. Click on the file.
   
   
3. Select "Next: Arrange your labels" in the bottom right corner of the screen.
   
   
4. Click "Address block" in the top right of your screen.
   
   
5. Click "OK" to insert recipients' names onto the labels.