How do you  merge 2 excel files?
<answer> 1 Open the first workbook, and then select the sheet that contains the information that you want to use in the mail merge. 2 Select the portion of the file containing the text. 3 On the Insert menu, point to Name, and then click Define. 4 Type a name, click OK, and then save the file. 5 Repeat steps 1-4 for the second file. <context> 1 Open the first workbook, and then select the sheet that contains the information that you want to use in the mail merge. 2  Select the portion of the file containing the text. 3  On the Insert menu, point to Name, and then click Define. 4  Type a name, click OK, and then save the file. 5  Repeat steps 1-4 for the second file. In the Word Mail Merge Helper, click Get Data, click Create Data Source, and then click MS Query. 2  With New Data Source selected, click to select the Use the Query Wizard to create/edit queries check box, and then click OK. 3  Type any name for your data source. 4  Under Select a driver, select Microsoft Excel Driver (*.xls) .