Mail+merge

=Mail Merge with Microsoft Word and Excel 2010=

toc

Creating Customized Letters
Check out this great tutorial on mail merge basics! > > . >
 * 1) Open an **existing Excel document**. If you want, you can use this file:
 * 1) Download this recipient list in **Word** format:
 * 1) Use the **Mail Merge Wizard** to merge the **letter** with the **recipient list**.
 * 2) Place an **Address Block** at the top of the page, and a **Greeting line** above the body of the letter.
 * 3) **Print** the document.

media type="custom" key="21710112"

Creating Labels
top

Create labels from a recipient list in Excel format:
top media type="custom" key="21710520"
 * Mailings à Start Mail Merge à Labels
 * Select Labels Type
 * Select Recipients à Use Existing List
 * Browse for the Excel file
 * Select the sheet in the workbook that contains the fields if necessary
 * Insert Merge Field
 * Select field, press Insert, Select next field, press Insert, repeat.
 * In main window, place cursor between carrots separating fields and press Shift + Enter
 * Repeat to separate all fields onto appropriate lines of label
 * Update Labels
 * Finish & Merge
 * Edit Individual Documents…
 * OK

Print a single label:
top > A blank document opens by default. Leave it open. If you close it, the commands in the next step are not available. > > If you want to create a label for an address that is stored in the electronic address book that is installed on your computer, click **Insert Address**. > > > The type of printer that you are using to print labels > The supplier that produced your label sheets > The number that corresponds to the product number listed on your package of label sheets > >
 * 1) Start Microsoft Word.
 * 1) On the **Mailings** tab, in the **Create** group, click **Labels**.
 * 1) In the **Address** box, type the text that you want.
 * 1) To change the formatting, select the text, right-click the selected text, and then click **Font** or **Paragraph** on the shortcut menu.
 * 2) To select the label type and other options, click **Options**.
 * 3) In the **Label Options** dialog box, make your choices, and then click **OK**.
 * 1) After you select the options that you want, click **OK**.
 * 2) Under **Print**, click **Single label**. Then in the **Row** and **Column** boxes, enter the numbers that match the numbers of rows and columns on the label sheet for the label that you want to print.
 * 1) Click **Print**.

Print a full sheet of the same label:
top > A blank document opens by default. Leave it open. If you close it, the commands in the next step are not available. > > If you want to create a label for an address that is stored in the electronic address book that is installed on your computer, click **Insert Address**. > All of the labels on the sheet will use the formatting that you specify. > > > The type of printer that you are using to print labels > The supplier that produced your label sheets > The number that corresponds to the product number listed on your package of label sheets >
 * 1) Start Word.
 * 1) On the **Mailings** tab, in the **Create** group, click **Labels**.
 * 1) In the **Address** box, type the text that you want.
 * 1) To change the formatting, select the text, right-click the selected text, and then click **Font** or **Paragraph** on the shortcut menu.
 * 1) To select the label type and other options, click **Options**.
 * 2) In the **Label Options** dialog box, make your choices, and then click **OK**.
 * 1) After you select the options that you want, click **OK**.
 * 2) Under **Print**, click **Full page of the same label**.
 * 3) Do one of the following:
 * To send the labels directly to the printer without previewing them, click **Print**.
 * To preview the labels so that you can edit them or add graphics to them and save them in a reusable document, click **New Document**.
 * Word creates a document that contains the sheet of labels. Word uses a table to lay out the labels. If you don't see lines separating the labels, click the **Layout** tab under **Table Tools**, and then in the **Table** group, click **View Gridlines**.
 * You can make any changes that you want to each label, including changes to the text formatting and color scheme, just as you would with the content of any table in Word. When you finish, save or print the labels the same way that you save or print any document in Word.

Create and Print Return Labels
top > A blank document opens by default. Leave it open. If you close it, the commands later in this procedure are not available. > Word stores the address so that you can use it whenever you want to insert your return address in a document. > > > > The type of printer that you are using to print labels > The supplier that produced your label sheets > The number that corresponds to the product number listed on your package of label sheets > >
 * 1) Start Word.
 * 1) Click the File tab.
 * 2) Click Options.
 * 3) Click **Advanced**.
 * 4) Scroll down, and under **General**, type your return address in the **Mailing address** box.
 * 1) Click **OK**.
 * 2) On the **Mailings** tab, in the **Create** group, click **Labels**.
 * 1) Select the **Use return address** check box.
 * 2) If you want to format the text in the **Address** box, select the text, right-click the selected text, and then click **Font** or **Paragraph** on the shortcut menu.
 * 3) To select the label type and other options, click **Options**.
 * 4) In the **Label Options** dialog box, make your choices, and then click **OK**.
 * 1) Under **Print**, do one of the following:
 * To print just one label, click **Single label**. Then in the **Row** and **Column** boxes, enter the row number and column number that match the label sheet location of the label that you want to print. Click **Print**.
 * To print a whole sheet of labels, under **Print**, click **Full page of the same label**, and then do one of the following:
 * To send the labels directly to the printer without previewing them, click **Print**.
 * To preview the labels so that you can edit them and save them in a reusable document, click **New Document**.
 * Word creates a document that contains the sheet of labels. Word uses a table to lay out the labels. If you don't see lines separating the labels, click the **Layout** tab under **Table Tools**, and then in the **Table** group, click **View Gridlines**.
 * You can make any changes that you want to each label, including changes to the text formatting and color scheme, just as you would with the content of any table in Word. When you finish, save or print the labels the same way that you save or print any document in Word.

Web Resources:
top 10 things you should know about printing labels in Word 2010