Excel 2007 : Link 2 workbooks on 2 different drives

Hi all!

So here's my problem: I work in the Admissions office of a small, private university, and we're currently going through our admissions period for the Summer quarter. Part of that involves printing out tracking sheets for each applicant. Normally we just print out the tracking sheet and fill them in by hand, but my boss wants to automate this process to make it the process smoother. So:

• Drive "J:\" has a Master List of all the current applicants (Excel 2007 format).
• Drive "M:\" has the Tracking Sheet with spots for the applicant's Name, Primary Phone Number, and Secondary Phone Number.

The Master List has the applicant's first and last names in separate cells, while the Tracking Sheet has a single cell for the Name. I was thinking I could just add an extra cell to the Master List to write the applicant's name in to.

So, basically, I'd like to do a mail merge in Excel. Is this possible?? Thanks for the help!

-Myles

Update:
I've figured out how to put the name cells into 1 cell from another drive. Now I just need to figure out how to make a mail merge-type thing with the other file. Thanks!
-M