The active document becomes the main document. Under Select document type, click Letters. In Microsoft Office Word 2007, click Start Mail Merge in the Start Mail Merge group on the Mailings tab, and then click Step by Step by Mail Merge Wizard. In Microsoft Office Word 2003 and in earlier versions of Word, point to Letters and Mailings on the Tools menu, and then click Mail Merge Wizard. HOW TO MAIL MERGE LABELS FROM EXCEL TO WORD USING WIZARD HOW TOFor example, in a mailing list, each row might include information about a particular recipient.Ĭreate your Excel data file, and then arrange it by using the fields that you want to use for your letter, as shown in the following sample data file.Īfter you create your Excel data file, save it, and then close the data file.įor more information about how to create a mail-merge address list, click the following article number to view the article in the Microsoft Knowledge Base:Ģ94688 How to design and set up a mail merge address list in Word 2002 and in later versions of Word The first row should contain field names for each column - for example, Title, Salutation, First Name, Middle Name, Last Name, Address1, and Address2.Įach row should provide information about a particular item. Note the following requirements for the data table: The text in an output document can be the same in all output documents, but you can apply formatting to specific documents.īefore you proceed with the Mail Merge Wizard, make sure that your Excel worksheet is well structured for this purpose. The output documents are the result of the mail merge. This database is typically a list of names, addresses, phone numbers, and other categories of personal information. For example, the recipient list is a Microsoft Access database file or an Excel worksheet. The recipient list is a database that contains the data that is to be merged into the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another. The main document contains the basic text that is the same in all of the output documents. When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents: This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge.How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet Connect and edit the mailing listĬonnect to your data source. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. Here are some tips to prepare your Excel spreadsheet for a mail merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |