Mail Merge entirely in Excel

[Unico]

--------------------------------------------------------------------------------

I know this is possible, I just don't know how to do it.

I have a form made in excel and data in another excel file.

What I would like to have happen is there are 3 boxes, Course Number, Course, and Instructor, that change for each course and instructor. If we could get those three cells to read the data correctly from the data excel file and populate on the form excel file that would decrease the amount of time it takes for us to print up these evaluations.

I made "mock" files that are exactly like what I'm working at. If anyone would like these files to play around and provide some help then you can email me at [email protected] Work doesn't allow me to use WinZip, sorry.

Thank you.

[royUK]

You could use VLOOKUP and automate it with VBA. If you can't use WINZIP or similar then used a file sharing site such as yousendit.com