How do you  merge 2 excel files?
 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. 