HOW TO MAIL MERGE FROM EXCEL HOW TO

On the Insert menu, point to Name, and then click Define. Select the portion of the file containing the text. Open the first workbook, and then select the sheet that contains the information that you want to use in the mail merge. When you connect the two files using Microsoft Query, you can retrieve all of the information about James Jones into a single data source.ДЄfter the files have been created, name the ranges of information in each sheet. That is, James Jones (IDNumber 1 in File1) should live at 333 3rd Ave (IDNumber 1 in File 2). That is, IDNumber 1 should represent the same employee in both sheets. That is, the column heading should be the same, and the information in File1 should correspond to the information in File2. The IDNumber column in File1 should be similar to the IDNumber column in File2. In these two sample Excel files, File1, cell A1 contains the word вЂњIDNumber,вЂќ cell B1 contains the word вЂњFirstname,вЂќ cell C1 contains вЂњLastname,вЂќ and cell D1 contains вЂњPosition.вЂќ In File2, cell A1 contains the word вЂњIDNumber,вЂќ cell B1 contains вЂњAddress,вЂќ and cell C1 contains вЂњSalary.вЂќДЄ1: IDNumber B1: Firstname C1: Lastname D1: PositionДЄ3: 2 B3: Harry C3: Anderson D3: Administration Each column of information needs a heading name (do not use spaces, quotation marks, apostrophes, or hyphens in the heading names). For the files to be combined inside Microsoft Query, the files must be in the correct format in Excel. This allows you to create a mail merge that contains the ID numbers, first names, last names, addresses, positions, and salaries. If the ID numbers in both files are the same, you can link the two files by using the similar (or common) ID field. One file can contain a list of ID numbers, first names, last names, and positions, and another file can contain a list of ID numbers, addresses, and salaries. Merging two Excel files allows you to combine related information into a single file.ДЇor more information about creating a mail merge data source in Microsoft Excel, click Microsoft Excel Help on the Help menu, type work with a mail merge data source in the Office Assistant or the Answer Wizard, and then click Search to view the topic. You may want to do this so that you can combine related information into a single file and use it in a Microsoft Word mail merge.

HOW TO MAIL MERGE FROM EXCEL HOW TO

This article describes how to use Microsoft Query to merge two Microsoft Excel 2000 files.

How to mail merge from excel