For my job I send out medical record requests for clients. I have one excel file containing all the hospital information where I send letter for the records. I have another excel file with a list of our client names and info that is needed to create the request.



My question is, how can I create a template where the address field is populated by the hospital excel file and the client info field is populated by the client info excel file.

I tried a regular mail merge, but it won't let me use two different excel files.

Any help would be very much appreciated.